DATE worksheet function

J

Jonathan Rynd

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

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
R

Ron Rosenfeld

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
 
J

Jonathan Rynd

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.
 
Top