Folks,
Dates in a certain file were typed in an informal manner: i.e. Sep-21-2005.  
Now, since this was entered as a text, Excel is not evaluating it as a Date
Format at all (even after I format the cell accordingly).  This is what I

I am trying to SUM by month, what is spent on different products or buckets.
The formula I have been trying to make work is:
'=SUMIF(D10:E40,(AND(MONTH(1),G3)),F10:F40) where:
RANGE=D10:E40.   Months are in Col D10:D40, and buckets are in E10:E40.

I need to have a field on a worksheet to show the file creation date.  It
can't be in the header or footer as I need to make calculations based on it.  
Any clues?
Regards,

Hi, I have four columns of data and would like to identify:
1-what is the first date a symbol was bought or sold  
2-On what dates did the number of shares for that symbol = 0 (like if
we bought 1000 and sold a total of 1000 a few days later)

Hopefully someone can help, The problem I have is that I want the formula
below to lookup one sheet and if the answer is there great, if not then
lookup the other sheet as the answer must be on this sheet, however the
formula below doesnt do it. Any help would be appreciated.

I'm trying to make a worksheet and I need any number over 60 to be equal to
60.  Or how can I make any negative number a zero?   Please help, I've tried
everything!!!

I have a worksheet with rows of information and varying coloumn headings.  I
am trying to find a way to be able to grab information from a single row and
pull it onto a separate worksheet.  (I want to be able to type in a
respective # on the separate worksheet and the ...

I get the formula to run okay, but I keep getting the year 1900...how do I
get 2005 or future years to appear?

Just this morning the quick key commands I normally use quit working.  The
commands were Shift + End, down key; to select a complete list
Another was double clicking on the drag and drop dot in the bottom right
corner of the cell to copy down the complete list.

I have a formula that looks as follows:
=VLOOKUP(A70,'Staffing Assumptions'!$A$64:$D$75,4,FALSE)
There are some values in Column A that are not in the Table Array contained
in 'Staffing Assumptions'!$A$64:$D$$75. When this happens the formula

This one has me puzzled...
In previous macros I've used this code if I wanted the criteria value
to = a value in a cell somewhere else.
Sheets("Data 1").Select

I was looking for a way to compare two groups of data on the same worksheet
then arrange the two groups of data based on the contents on one column in
each group. These two groups will have at least one row in common that I want
to line up side by side along with their counter ...

I am trying to create a master accrued leave workbook.
I want an action to take place on the last day of each month.
That action is to insert a value of "14".

Hey guys im making an excell document, i want to make a function tha
does this :
adds all the filled out cells(not the empty ones) and divides them b
their number (again ignoring the empty ones) so that if i have a ro

I have a worksheet that looks as follows:
           (SHEET 1)
    A              B              C
Location    Start Date    Monthly Estimate