Results 1 to 2 of 2

Thread: Due dates

  1. #1
    Join Date
    May 2008
    Posts
    1

    Unanswered: Due dates

    I wish to determine when I have a contract coming due in the next 45 days and provide a note that warns me that the payment is coming due.

  2. #2
    Join Date
    Feb 2004
    Posts
    533
    You can use an 'If' formula. With this formula the Due date is in Column B. The note appears in the cell with the formula. this checks for dates 45 days or less and if 45 or less, checks if it is 10 days or less.

    =IF(TODAY()-B2<=45,IF(TODAY()-B2<=10,"Due Within 10 Days!","Due Within 45 Days"),"")
    ~

    Bill

Posting Permissions

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