Can I add a 3rd auto text to my date condition

[PTMD]

Hi all,
I have a spread sheet that gives me 2 auto text options in Column J based on the date in Column I. I would like to add a 3rd auto text option into Column J if possible.
Can you assist and point me in the right direction to include a 3rd option called 'Recall Now' at Column J. This would be based on the condition of 28 days prior to the calibration becoming overdue.
I hope that makes sense.

I am using Excel 2013

Thank you in advance
SteveCalibration Register_New.xlsx

[jsuarezg]

You can put another IF inside the first If. In the part of the formula where you have "Overdue" put the other IF, with the condition of the 28 days and the text that you want ("Recall NOw") and the "Overdue" text.

[sktneer]

May be this...

Please Login or Register  to view this content.

[PTMD]

Thanks Guys,
Your blood is worth bottling, my spreadsheet works well.
A big Thank You to you both.

Steve