Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I find the exact years and days between 2 dates?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I find the exact years and days between 2 dates?
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I find the exact years and days between 2 dates?
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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") |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number of years/months/days between 2 dates | Excel Worksheet Functions | |||
How do get the years and days Between two dates | Excel Discussion (Misc queries) | |||
Find the number of years between two dates | Excel Discussion (Misc queries) | |||
Number of years, months, days between two dates. | Excel Worksheet Functions | |||
difference between two dates in years, months and days. | Excel Worksheet Functions |