ExcelBanter - Day Conversion

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Day Conversion (https://www.excelbanter.com/excel-worksheet-functions/157769-day-conversion.html)

Michael

Day Conversion

If I have a number let's say 250 how can I return September 7, 2007

Raul

Peo Sjoblom

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

Don Guillett

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

Teethless mama

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

All times are GMT +1. The time now is 11:44 AM.