how do i use the daye function to insert a serial number
 

how do i use the date function to insert a formula that inserts a serial
number for a specific date

how do i use the daye function to insert a serial number
 

If you format the cell where the date is entered as 'number' then this gives
a unique number. However I suspect what you need is not so simple and
therefore requires fuller explanation please.


--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"stephanieylalo" wrote:

how do i use the date function to insert a formula that inserts a serial
number for a specific date

how do i use the daye function to insert a serial number
 

See help on DATEVALUE function.

=DATEVALUE("2/20/2010") or "20/2/2010" depending upon Regional settings
for date entry.


Gord Dibben MS Excel MVP

On Sat, 20 Feb 2010 06:17:01 -0800, stephanieylalo
wrote:

how do i use the date function to insert a formula that inserts a serial
number for a specific date