| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Day Conversion
If I have a number let's say 250 how can I return September 7, 2007
Raul |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Day Conversion
With 250 in A1
=DATE(2007,1,)+A1 -- Regards, Peo Sjoblom "Michael" wrote in message ... If I have a number let's say 250 how can I return September 7, 2007 Raul |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Day Conversion
=DATEVALUE("12/31/06")+250
-- Don Guillett Microsoft MVP Excel SalesAid Software "Michael" wrote in message ... If I have a number let's say 250 how can I return September 7, 2007 Raul |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Day Conversion
=DATE(YEAR(TODAY()),1,A1)
"Michael" wrote: If I have a number let's say 250 how can I return September 7, 2007 Raul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ESN conversion | Excel Worksheet Functions | |||
| Conversion | Excel Discussion (Misc queries) | |||
| pdf conversion | Excel Worksheet Functions | |||
| Between conversion | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
Linear Mode
