Posted to microsoft.public.excel.worksheet.functions

Jan Kronsell[_5_] Jan Kronsell[_5_] is offline

external usenet poster

Posts: 10

Problems when using Date() function.

I have the following function =Date(1900,1,1+A1) (A1 containing 367) and it returns 02-01-1901 (Danish notation) as expected. If A1 instead contains 41012, I expect it to return 14-04-12 (41013), but it does not. It returns 16-09-89
(32767).

Is there a limitation to the final argument in the Date function, that I'm not aware of and in that case, what is it=

Jan

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 problems	Gerry[_2_]	Setting up and Configuration of Excel	1	September 28th 07 12:42 PM
Date problems	edluver	Excel Programming	2	April 13th 07 03:08 AM
date problems	piute	Excel Discussion (Misc queries)	14	December 7th 06 03:22 PM
Function-Date Problems	Brian Matlack	Excel Worksheet Functions	4	May 18th 06 10:07 PM
Date Problems	Dean[_8_]	Excel Programming	5	July 26th 05 08:35 AM

All times are GMT +1. The time now is 10:23 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us