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 |