Forum Discussion
Gerhard100
Jan 22, 2020Copper Contributor
using running dates in Excell to convert to text
Good day. I have the following Excel tables that with formulas must convert to number and text. The cycle is yearly. Thus said, person starts on a specific date. He / She is then shown as a 1st y...
SergeiBaklan
Jan 22, 2020Diamond Contributor
I'd simplify to
=IFS(TODAY()>=EDATE(A2,24),"3rd",TODAY()>=EDATE(A2,12),"2nd",TRUE,"1st")Riny_van_Eekelen
Jan 22, 2020Platinum Contributor
SergeiBaklan Indeed! And more elegant.