DATE worksheet function

  • Thread starter Thread starter Jonathan Rynd
  • Start date Start date
J

Jonathan Rynd

Does anybody know where I can get a list of all the date formats that the
DATE() worksheet function accepts?
 
Hi Jonathan!

See Help for the DATE function.

All three arguments are numeric and the entry must be a number or a
formula or function that returns a number.

How Excel interprets various number inputs is covered quite clearly by
Help.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Does anybody know where I can get a list of all the date formats that the
DATE() worksheet function accepts?
Click to expand...

The DATE() worksheet function does not accept any particular date formats. It
has three arguments: year, month, day. E.g. =DATE(2004,1,12) would yield the
serial number for 12 January 2004.


--ron
 
Hi Jonathan!

See Help for the DATE function.
Click to expand...

Oops -- I meant to ask about the DATEVALUE function, but it apparently
takes the same date formats as Excel accepts in cells.
 
Back
Top