From: threee11 on 4 Feb 2010 12:14 I am attempting to find the difference between two dates (in terms of days, months, and years) but I always get an additional month added on. Why? And how can I fix? For instance, if I want to find the difference between 1/1/2010 and 2/1/2010; it returns 2/0/0 From: Mike H on 4 Feb 2010 12:23 Have a look at Chip Pearson's explanation of DATEDIF =DATEDIF(A1,B1,"y")&" years "&DATEDIF(A1,B1,"ym")&" months "&DATEDIF(A1,B1,"md") &" days" http://www.cpearson.com/EXCEL/datedif.aspx be careful ewith this because it can throw up some odd results and if you search this forum you'll discover what they are -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "threee11" wrote: > I am attempting to find the difference between two dates (in terms of days, > months, and years) but I always get an additional month added on. Why? And > how can I fix? > > For instance, if I want to find the difference between 1/1/2010 and > 2/1/2010; it returns 2/0/0 From: Eduardo on 4 Feb 2010 12:25 Hi =DATEDIF(D5,E5,"y")&" years "&DATEDIF(D5,E5,"ym")&" months "&DATEDIF(D5,E5,"md")&" days" "threee11" wrote: > I am attempting to find the difference between two dates (in terms of days, > months, and years) but I always get an additional month added on. Why? And > how can I fix? > > For instance, if I want to find the difference between 1/1/2010 and > 2/1/2010; it returns 2/0/0  |  Pages: 1 Prev: Formula in 07Next: Auto Signature in Excel Send