| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO i INSERT A RANGE OF SERIAL DATES IN THE WORKDAY FUNCTION | Excel Worksheet Functions | |||
| Serial Number | Excel Worksheet Functions | |||
| Look up part of a number within a serial number and cpy back assoc | Excel Worksheet Functions | |||
| Formula for serial number | Excel Discussion (Misc queries) | |||
| serial number cell | Excel Worksheet Functions | |||
Linear Mode
