LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default Datedif gives wrong result

Beginning Date Ending Date months
11/30/2009 12/31/2009 1
11/30/2009 1/31/2010 2
11/30/2009 2/28/2010 2
11/30/2009 3/31/2010 4

I'm a bit puzzled. Beginning Date is in A1. Ending date in B1 and my
datedif formula in column C.

The formula starting in C2 is =DATEDIF(A2,B2,"m"). Shouldn't February be
equal to 3? Based upon Chip's site, I'm guessing that it has something to do
with leap year but the last one was in 2008 and the next one is in 2012 so
neither Date1 or Date2 have a leap year.

I've tried different beginning dates but January and February give the same
result. Obviously it is something to do with February.

Unfortunately I'm using Excel 2003 SP3. Windows XP SP3.

Any other way to find the number of months inbetween two dates?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Displays wrong result FirstVette52 Excel Worksheet Functions 2 July 21st 09 11:18 PM
excel result return wrong calcuation result garyww Excel Worksheet Functions 1 August 14th 06 11:14 AM
excel result return wrong calcuation result garyww Excel Worksheet Functions 0 August 14th 06 05:02 AM
excel result return wrong calcuation result garyww Excel Worksheet Functions 0 August 14th 06 05:02 AM
My Datedif function only returns 0's in the cell what's wrong? Tom Excel Worksheet Functions 1 April 13th 06 07:43 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"