How do I find the exact years and days between 2 dates?
 

How do I find the exact years and days between 2 dates?
 

Check this out:

http://www.cpearson.com/excel/datearith.htm

How do I find the exact years and days between 2 dates?
 

Thank you.

"Colby Africa" wrote:

Check this out:

http://www.cpearson.com/excel/datearith.htm

How do I find the exact years and days between 2 dates?
 

And more specifically, http://www.cpearson.com/excel/datedif.aspx
--
David Biddulph

"Colby Africa" wrote in message
ups.com...
Check this out:

http://www.cpearson.com/excel/datearith.htm

How do I find the exact years and days between 2 dates?
 

On Nov 14, 5:30 pm, jland wrote:


try this:
=dateif(date1, date2, "Y")

How do I find the exact years and days between 2 dates?
 

On Nov 14, 5:30 pm, jland wrote:
How do I find the exact years and days between 2 dates?

Use DATEDIF. Example assumes the two dates are in C28 and D28:

=DATEDIF(MIN(C28,D28),MAX(C28,D28),"y")&" years,
"&DATEDIF(MIN(C28,D28),MAX(C28,D28),"md")&" days"

Use this formula if you want the days to be inclusive:

=DATEDIF(MIN(C28,D28),MAX(C28,D28),"y")&" years,
"&DATEDIF(MIN(C28,D28),MAX(C28,D28),"md")+1&" days"

Here's a reference:
http://www.cpearson.com/excel/datedif.aspx

How do I find the exact years and days between 2 dates?
 

You presumably mean DATEDIF, not DATEIF ?

I've suggested the use of http://www.cpearson.com/excel/datedif.aspx which
will also show the syntax to get the days part to add to the number of
years.
--
David Biddulph

"SGT Buckeye" wrote in message
ups.com...
On Nov 14, 5:30 pm, jland wrote:


try this:
=dateif(date1, date2, "Y")