T.,

Make sure that the dates are actual dates, and not strings. Excel can't do
math (easily at least) on strings that only look like dates. The date cells
should be formatted as dates, and should show something like

6/15/2005

in the formula bar, no matter what shows on the spreadsheet.

If it doesn't, format the cells for date, then put a 1 into a blank cell,
copy that cell, then select your dates and choose pastespecial / multiply,
and press OK. That will cause Excel to convert the strings into actual
dates, and then the formula will at least have a better chance of working.

If you can't get it to work, contact me privately by replying to me through
this message, and take the spaces out of my address and change the dot to .
Attach a copy of your workbook, and I will fix it to work.

HTH,
Bernie
MS Excel MVP


"onesidered" wrote
in message ...

Thank you for the swift replies... Bernie... I have entered everything
as you indicated... and I don't know what to do next... This is a
little more advanced than I am with Excel. I have followed your
instruction to a T.... I just need to know what comes next?

Sorry for my lack of competence in excel.... HELP...

Thanks again,
T.


--
onesidered
------------------------------------------------------------------------
onesidered's Profile:
http://www.excelforum.com/member.php...o&userid=25977
View this thread: http://www.excelforum.com/showthread...hreadid=393435