Posted to microsoft.public.excel.misc

santhu

external usenet poster

Posts: 3

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert Date to number?	JethroUK©	Excel Worksheet Functions	6	May 8th 06 10:15 PM
Convert Date to Serial Date?	DTTODGG	Excel Discussion (Misc queries)	5	April 21st 06 08:33 PM
date displays as serial number	et	Excel Discussion (Misc queries)	2	April 19th 05 01:10 AM
How do I convert Date serial number to date	rdunne	Excel Worksheet Functions	1	April 12th 05 03:04 PM
How do I convert a Julian date into a regular date?	Jessica	Excel Discussion (Misc queries)	4	December 2nd 04 02:54 AM

All times are GMT +1. The time now is 05:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us