date format frustration!

O

ogawak

I'm having no luck! When I enter 07/29/2004 it comes out 36735. I've tried
the format option but no luck...what am I missing?

Thanks in advance!
 
G

Gord Dibben

Check your Date settings at Tools>OptionsCalculations.

Uncheck the 1904 date system.

Your dates are off by 1462 days.

36735 is July 28, 2000

Gord Dibben Excel MVP
 
Top