Any acceptable date format should work, including date/time...

6/1
6-1
worked for me in Excel 2000.

Just make sure that you don't enter them as Text.

--
steveB

Remove "AYN" from email to respond
"Losse" wrote in
message ...

I tried this by just putting the dates as "6-1" for example into the
cells and doing it from there. This didn't work. How do I do it
correctly?


--
Losse
------------------------------------------------------------------------
Losse's Profile:
http://www.excelforum.com/member.php...o&userid=24813
View this thread: http://www.excelforum.com/showthread...hreadid=387298