Microsoft Office Forums - View Single Post - Have dates respect plurality...

Thread: Have dates respect plurality...

View Single Post

Old

07-30-2018, 11:35 PM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,100

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

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

Reply With Quote