convert serial number into date
 

Hi,

Can anyone tell me how to convert a serial number into date?

For example:

01-OCT-06 is stored as 38991 in MS excel (i get this thru edate
function). I want to get the date using the serial number 38991.

thanks
Santhu

convert serial number into date
 

Just Format as Date (FormatCellsNumber tab, Category Date, choose a format)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"santhu" wrote in message oups.com...
| Hi,
|
| Can anyone tell me how to convert a serial number into date?
|
| For example:
|
| 01-OCT-06 is stored as 38991 in MS excel (i get this thru edate
| function). I want to get the date using the serial number 38991.
|
| thanks
| Santhu
|

convert serial number into date
 

Or, if you want text: =TEXT(A1,"dd-mmm-yy")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"santhu" wrote in message oups.com...
| Hi,
|
| Can anyone tell me how to convert a serial number into date?
|
| For example:
|
| 01-OCT-06 is stored as 38991 in MS excel (i get this thru edate
| function). I want to get the date using the serial number 38991.
|
| thanks
| Santhu
|