Posted to microsoft.public.excel.misc

Bob@HP

external usenet poster

Posts: 2

Unexpected value with date calculation

b2 is set to =DATE(2007,6,9)
i5 is set to =DATE(2007,6,10)
h10's formula is =DATEDIF(I5,B2,"Y")

I'm expecting an answer of 0, but I get 107. The format of H10 is set to
general.

Any suggestions?

Thanks,

Bob

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
End Date Calculation (adding a start date duration)	Silena K-K	Excel Discussion (Misc queries)	5	January 25th 08 04:27 PM
Date Calculation	WLMPilot	Excel Discussion (Misc queries)	4	December 19th 07 10:27 PM
calculation unexpected	zxcv	Excel Discussion (Misc queries)	7	July 13th 07 04:03 PM
Tricky Date calculation: How to calculate a future date	[email protected]	Excel Discussion (Misc queries)	9	August 11th 06 04:24 AM
Help please... Simple calculation - with unexpected results	MLK	Excel Worksheet Functions	7	July 29th 06 12:03 AM

All times are GMT +1. The time now is 10:11 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us