Calculating a Due Date with criteria

Topic

New Reply

Goal:
Create a list of contracts and due dates for annual maintenance fees.

Determine when a contract is coming due in the next 45 days.
Create a message that warns when the payment is coming due.

I created the formula:
=IF(E4=””,””,IF(E4DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY())),”Current”,”Expires Soon”)))

“E4” had the end date of the contract.

I feel that there is a much easier/more accurate way to do it.
Instead of the “Current”, “Expires Soon”, “Expired” with the actual number of days until it is due. i.e. “Due in # days”

Reply | Quote

Replies

How about something like this:
=IF(E4=””,””,IF(E4< TODAY(),"Expired","Due in " & E4 – TODAY() & " day(s)"))

Reply | Quote

Barron, That is sweet!

Perfect, TY

Reply | Quote