View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
santhu santhu is offline
external usenet poster
 
Posts: 3
Default 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