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

  • Thread starter Thread starter stephanieylalo
  • Start date Start date
S

stephanieylalo

how do i use the date function to insert a formula that inserts a serial
number for a specific date
 
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
 
Back
Top