convert serial number into date

  • Thread starter Thread starter santhu
  • Start date Start date
S

santhu

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
 
Just Format as Date (Format>Cells>Number tab, Category Date, choose a format)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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
|
 
Or, if you want text: =TEXT(A1,"dd-mmm-yy")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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
|
 
Back
Top