DATE worksheet function

[Jonathan Rynd]

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

 

[Norman Harker]

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.

 

[Ron Rosenfeld]

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

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

 

[Jonathan Rynd]

Hi Jonathan!

See Help for the DATE function.

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