Formula for status

RSanders

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

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