• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. N

    Excel 2007

    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 :)
  2. N

    Excel 2007

    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...
  3. N

    Excel 2007

    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.
Back
Top