Posted to microsoft.public.excel.programming

Chet

external usenet poster

Posts: 88

Date conversion question

Am trying to understand why is that when I have a variable MaxDate
(undeclared) and is has a value of 38697 and if I use
=TEXT(MaxDate,"mm/dd/yy") I get the correct value of 12/12/09 but if I
use function =CDATE(MaxDate) I get 12/11/2005 as an output? Also the
format command didn't work either to convert MaxDate with the code
=format(MaxDate, "mm/dd/yy") as it also gave 12/11/2005 when the
correct output was 12/12/09. I am trying to understand this.

Thanks,
Chet

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
Date conversion	SITCFanTN	Excel Programming	11	June 8th 06 11:06 PM
conversion question	Tammi P	Excel Programming	4	May 24th 06 03:23 AM
Another Time Conversion question	Sean Skallerud	Excel Discussion (Misc queries)	1	August 24th 05 05:17 PM
Time Conversion question	Sean Skallerud	Excel Discussion (Misc queries)	4	July 21st 05 08:53 PM
date conversion question	WIlliam Barnes	Excel Programming	4	February 29th 04 06:57 PM

All times are GMT +1. The time now is 01:46 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us