Can sumproduct return the weekday from just the mm/dd/yyyy format? I have the date mm/dd/yyyy in column a and sales dollars in column b. I would like just...

Can I also have the sumproduct formula allso look at the mm/dd/yyyy date format in column A and return just specific weekdays such as Tuesdays? Or Week Number...

I would like to be able to transfer the value from the LAST used cell in a column in one worksheet into a cell on a different worksheet..is this...

I have the cells of a worksheet linked to cells of another worksheet in another workbook. (I used "Special Paste"_"Paste Link") The conditional formatting is...

I want to concatenate with a "hard return". Using the formula: =concatenate(A1," ",B1) what would I use between the parentheses to insert a hard return? ...

Hi I have a spreadsheet to manage all my quarterly and annual subscriptions. Of course the subscriptions all occur in different months. Currently I have the...

Hello, So I have a Form and in there I have several check boxes. Some of them have the same value, like 1 $. I want when I choose more check boxes he...

how can I solve this problem? Please help me & See my link http://www.mediafire.com/?sharekey=94cb1c06b8ccffc1d2db6fb9a8902bda

How do I change a cell whose content is hh:mm:ss and the value might be 267:45:00 to a format that displays the days:hours:minutes? Is this possibe?

Hi everyone, I'm using the MS Excel online template numbered TC062071411033. In the cell that calculates the hours worked from the time that the user inputs...

I have a table of data, one column of which is a date (when the entry was created). I want to create a summary table, of how many entries for each calander...

I created a LIST Data Validation (I typed the entries into the window) for an entire column. When I paste into the column or download data into the column,...

I have a spreadsheet that will constantly updated by customers. I want to create a formula to automatically summarize a list of various components. For...

First day with 2007 Excel. Is there a way to get the classic excel view? I don't use the mouse, so I'm not really liking the new format. Is there a way to...

I download a csv report that has two columns that I'd like to work with. 1-session start (custom format) "11/6/2008 16:59" 2-session end, same format, end of...

Does anyone have any suggestions on how to count it? There is a list of date under column A, and I would like to count the number of date, which is not equal...

It seems to be an easy task however I keep getting #N/A-- I have checked so far: - the "table array" is sorted - both "look up value" and the "table array"...

I am trying to get an average of list, but if there are more than 6 numbers in the list to only use the top 6 values. My first thought was some sort of sum...

I need a macro that will export data from one worksheet to anther when it is printed

The spreadsheet was created from an Access query where the column is defined as double with 2 decimil places. In Excel I expand the column to 30 decimal...