Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Edison, New Jersey, USA
    Posts
    215
    Thanks
    4
    Thanked 0 Times in 0 Posts
    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(E4<TODAY(),"Expired",IF(E4>DATE(YE AR(TODAY()),MONTH(TODAY())+1,DAY(TODAY())),"Curren t","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"

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    How about something like this:
    =IF(E4="","",IF(E4< TODAY(),"Expired","Due in " & E4 - TODAY() & " day(s)"))

  3. #3
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Edison, New Jersey, USA
    Posts
    215
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Barron, That is sweet!

    Perfect, TY

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •