toony
New member
I'm a bit new to excel, or may be not so new but very green yet specially when it comes to nesting functions.
The below is to get how many years, months and days have passed since a given date.
It worked fine except that it would give me years/months/days even if it was just the 1 month (1months instead). With help I managed to sort out the days but tried different ways to get the same for the years and for the months but really struggling to nest the IF function to get month or months respectively and year or years.
=DATEDIF(H4,TODAY(),"y")&" years,"&DATEDIF(H4,TODAY(),"ym")&" months, "&DATEDIF(H4,TODAY(),"md")&IF(DATEDIF(H4,TODAY(),"md")>1," days"," day")
The below is to get how many years, months and days have passed since a given date.
It worked fine except that it would give me years/months/days even if it was just the 1 month (1months instead). With help I managed to sort out the days but tried different ways to get the same for the years and for the months but really struggling to nest the IF function to get month or months respectively and year or years.
=DATEDIF(H4,TODAY(),"y")&" years,"&DATEDIF(H4,TODAY(),"ym")&" months, "&DATEDIF(H4,TODAY(),"md")&IF(DATEDIF(H4,TODAY(),"md")>1," days"," day")