Formula for status

RSanders · 02/27/19

Hi,

Can I please have help with a formula.

I want to show in a status column the following status':

Current - if expiry date hasn't been reached

Expiring Soon - If expiry date is in the next 60 days

Expired - If expiry date is today or greater than today

Column name for Date is "Expiry Date"

Thanks, really appreciate any help

Debbie Sawyer · 02/28/19

Hi RSanders

Try:

=IF([Expiry Date]1 < TODAY(), "Expired", IF([Expiry Date]1 < TODAY() + 60, "Expiring Soon", "Current"))

I believe this works to your logic!

Kind regards

Debbie Sawyer Consultant & Training Manager

Smarter Processes mean happy people in successful businesses

Comments