Yes, its critical. Believe you are not entering the dates as real dates
recognized by Excel. To convert it all (what you have entered) at one go to
real dates, select the col range of "dates", click Data Text to Columns.
Click NextNext. In step 3 of the wiz., under Column data format, check
"Date", then choose from the droplist: YMD, click Finish. The earlier
expression should now work beautifully.

Play it safe when you are keying-in dates. Never be lazy. Always key-in the
FULL date, inclusive of the month and the year.

I'd key-in dates like this:
28Jun2009
using an unambiguous "mmm" for the month, and "yyyy" for the year
I won't go wrong doing this.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"freebee" wrote:
Hi, I tried it and it returns 0. My date is entered as 2009-6-1, 2009-6-5,
etc.
Could that be the problem?
Thanks.