Date Question

  • Thread starter Thread starter dcronje
  • Start date Start date
D

dcronje

Why when I use the Date function eg.
=DATE(3,6,30)

return a date of 30 June 1903

AFAIK excel returns 200x for year entries from 00 to 29 then it revert
back to 1900.

Do I have a setting that is wrong or have I just misunderstoo
something?

Thanks
Davi
 
David,

In Date, if you want 2003, you have to specify it, =DATE(2003,6,30).

The point you are making refers to direct input of dates, that is 30/06/03
in a cell.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top