| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number of years/months/days between 2 dates
I am looking for a formula that gives me the number of years, months and days
between two dates. e.g. 03/02/1998 - 20/07/2005 (dd/mm/yyyy) Result: 7 years, 5 months, 17 days e.g. 01/01/2005 - 01/03/2006 Result: 1 year, 2 months, 0 days Thank you for your time. Deborah |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Number of years/months/days between 2 dates
Deborah wrote: I am looking for a formula that gives me the number of years, months and days between two dates. e.g. 03/02/1998 - 20/07/2005 (dd/mm/yyyy) Result: 7 years, 5 months, 17 days e.g. 01/01/2005 - 01/03/2006 Result: 1 year, 2 months, 0 days Thank you for your time. Deborah Hi Deborah, Maybe you can use something like this: =DATEDIF(A1,A2,"y") & " years, " & DATEDIF(A1,A2,"ym") & " months, " &DATEDIF(A1,A2,"md") & " days" With the two dates in A1 and A2 Regards, Bondi |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Number of years/months/days between 2 dates
Thank you very much Bondi
"Bondi" wrote: Deborah wrote: I am looking for a formula that gives me the number of years, months and days between two dates. e.g. 03/02/1998 - 20/07/2005 (dd/mm/yyyy) Result: 7 years, 5 months, 17 days e.g. 01/01/2005 - 01/03/2006 Result: 1 year, 2 months, 0 days Thank you for your time. Deborah Hi Deborah, Maybe you can use something like this: =DATEDIF(A1,A2,"y") & " years, " & DATEDIF(A1,A2,"ym") & " months, " &DATEDIF(A1,A2,"md") & " days" With the two dates in A1 and A2 Regards, Bondi |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Number of years/months/days between 2 dates
On 7 Jul 2006 01:32:46 -0700, "Bondi" wrote:
Deborah wrote: I am looking for a formula that gives me the number of years, months and days between two dates. e.g. 03/02/1998 - 20/07/2005 (dd/mm/yyyy) Result: 7 years, 5 months, 17 days e.g. 01/01/2005 - 01/03/2006 Result: 1 year, 2 months, 0 days Thank you for your time. Deborah Hi Deborah, Maybe you can use something like this: =DATEDIF(A1,A2,"y") & " years, " & DATEDIF(A1,A2,"ym") & " months, " &DATEDIF(A1,A2,"md") & " days" With the two dates in A1 and A2 Regards, Bondi Because of the way DATEDIF handles months with different days, there are some potential pitfalls. For example: 31-Jan-2005 1-Mar-2006 1 years, 1 months, -2 days --ron |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Number of years/months/days between 2 dates
On Fri, 7 Jul 2006 01:06:01 -0700, Deborah
wrote: I am looking for a formula that gives me the number of years, months and days between two dates. e.g. 03/02/1998 - 20/07/2005 (dd/mm/yyyy) Result: 7 years, 5 months, 17 days e.g. 01/01/2005 - 01/03/2006 Result: 1 year, 2 months, 0 days Thank you for your time. Deborah Because of the fact that neither years, nor months, always have the same number of days, you can get unexpected results unless you define very clearly what you want. For example, Bondi's formula will work usually. But: 31-Jan-2005 1-Mar-2006 1 years, 1 months, -2 days --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| WORK OUT NUMBER OF WEEKS BETWEEN TWO DATES | Excel Worksheet Functions | |||
| Calculate Number of Days Between Dates Minus Weekends | Excel Discussion (Misc queries) | |||
| calculate number of days btw dates | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Find number of days between to dates | Excel Worksheet Functions | |||
Hybrid Mode
