Hi All
I use this formula to give the time elapsed form the date showing in B6
Code:
="("&DATEDIF(B6,TODAY(),"y")&" years "&DATEDIF(B6,TODAY(),"ym")&" months "&DATEDIF(B6,TODAY(),"md")&" days"&")"
It works perfectly well , but has certain anomalies. For example it will make Days , Month and Years plural when there may only be one of each involved.
EG 1 Days , 1 Months , 1 Years
Can someone suggest a modification of the formula to give respect to single months , days and years?
EG 1 Day , 1 month , 1 Year
Grateful for any advice.