Thanks a lot Narayank & SirJB7 :)
@Narayank: its really surprising to see that the error is till 14 Jan 2012 only. Wonder why!!! When i change the date to 16 Jan 2012, the formula gets correct. I must say great Observation.
@SirJ: Thanks for the bypass formula :)
Thanks Hui :)
I've been using this function from last 6 yrs, but for the first time i've faced this error. Specifying examples below to clarify my doubt.
Eg 1:
Start date: 15 Nov 2009
End date: 12 Jan 2011
function:datedif(start_date, End_date, "md")
Result: 28....Correct
Eg 2:
Start...
Excel 2007 is calculating wrong no. of days where the start date is of 2011 & end date of 2012. Function: datedif(start_date, end_date, "md")+1.
Pls help me in resolving this issue as it is related to my daily work activity.