Thread: how do i use the daye function to insert a serial number
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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

Reply With QuoteReply With Quote