Posted to microsoft.public.excel.worksheet.functions

ArcticWolf ArcticWolf is offline

external usenet poster

Posts: 70

Date returns always returns: 00 January 1900

Hi,

I've formatted cell to - Number Date*14 March 2001

I type in todays date 11/9/08, but it returns 00 January 1900. If I type
the formula =today() then it returns the correct date in the correct format.

Any ideas why it wont return the correct format/date.

Thanks in advance,

AW

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
UDF that returns a date	ep	Excel Worksheet Functions	5	January 19th 08 10:24 AM
Vlookup returns bad date	slrog123	Excel Discussion (Misc queries)	3	September 21st 07 12:31 AM
Date function returns #NUM!	[email protected]	Excel Worksheet Functions	5	May 10th 06 06:15 PM
Date+ returns #Num	kit	Excel Worksheet Functions	7	October 23rd 05 06:57 PM
dates start at 01 January 1900	melo	Charts and Charting in Excel	6	August 31st 05 03:36 AM

All times are GMT +1. The time now is 05:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us