Forum Discussion

SGeorgie's avatar
SGeorgie
Brass Contributor
May 24, 2023

Formula to show if date is overdue by 7months+

Hi

 

How do I write a formula to say if a date is over 7months old to enter "7m(+) overdue"

 

I have this but can't seem to enter 7m bit...

 

=IF(A1<TODAY(),"Overdue","")

 

 

Help please

 

 thanks

1 Reply

Resources