Prev: Formula in 07
Next: Auto Signature in Excel Send
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 07
Next: Auto Signature in Excel Send