| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for converting xx/xx/xxxx dates to a number between 1 and
I need an Excel formula to convert a date (mm/dd/yyyy) to a serial number,
i.e. January 1st = 001, 1st February = 032, 31st and so on to December 31st = 365 . The serial number needs to reset to 001 on Jan 1st of each new year. Is there a quick way to convert any given date from any given year to this 3-digit day number? Thanks in advance, Rodney |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates converting to MS serial number | Excel Discussion (Misc queries) | |||
| How do I changet a text telephone number (xxx) xxx-xxxx to xxxxxx. | Excel Worksheet Functions | |||
| Format a number (i.e. 1111111111111111) to show XXXX-XXXX-1111-11 | Excel Discussion (Misc queries) | |||
| change dots to dashes in an account format (xx.xxxx.xxxx) to xx-xx | Excel Discussion (Misc queries) | |||
| Converting dates to a number | New Users to Excel | |||
Threaded Mode
