ExcelBanter - Date Count

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Date Count (https://www.excelbanter.com/excel-discussion-misc-queries/126289-date-count.html)

SgMike

Date Count

Hi all ...

I would like to know if Excel can count the number of Years and Months for a
duration (E.g from 1 Jan 2005 to 1 Dec 2006). With a formula set, it gives
you the answer as 1 Year 11 months.

Gary''s Student

Date Count

=DATEDIF(A1,A2,"y") & " years, " & DATEDIF(A1,A2,"ym") & " months, " &
DATEDIF(A1,A2,"md") & " days"

if the dates are in A1 and A2
--
Gary's Student
gsnu200701

"SgMike" wrote:

Hi all ...

I would like to know if Excel can count the number of Years and Months for a
duration (E.g from 1 Jan 2005 to 1 Dec 2006). With a formula set, it gives
you the answer as 1 Year 11 months.

All times are GMT +1. The time now is 03:10 PM.