Have dates respect plurality...

[Chayes]

Hi All




I use this formula to give the time elapsed form the date showing in B6

="("&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.

[xor]

="("&DATEDIF(B6,TODAY(),"y")&IF(DATEDIF(B6,TODAY() ,"y")=1," year ","years")&DATEDIF(B6,TODAY(),"ym")&IF(DATEDIF(B6, TODAY(),"ym")=1," month "," months ")&DATEDIF(B6,TODAY(),"md")&IF(DATEDIF(B6,TODAY(), "md")=1," day "," days"&")")

[Chayes]

OK thanks for this. This resolves the issue first time.Much appreciated.