Results 1 to 11 of 11

Need to calculate when a date is = or less than 30 days prior to today's date

Threaded View

  1. #1
    Registered User
    Join Date
    04-07-2016
    Location
    Houston, Texas
    MS-Off Ver
    Home and Business 2013
    Posts
    3

    Need to calculate when a date is = or less than 30 days prior to today's date

    I manage truck drivers and I need a way to be notified when their license and/or medical cards are within 30 days of expiration. For example, if a drivers license expires May 7, 2016 - I need the cell to turn red today (April 7, 2016). I have the formula =E3-30 to let me know what day is 30 days prior to expiration. But I need that cell to turn red when it's 30 days from any given "today". Hope I explained this okay...Thank you for any help.
    Last edited by tk3god; 04-07-2016 at 11:45 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculate number of days between invoice date and today's date
    By JHerrick in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-30-2020, 03:53 PM
  2. calculate number of days between a date and today
    By South texas man in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-20-2020, 04:58 PM
  3. [SOLVED] I need a formula to always calculate exactly 21 days from today's date.
    By phxfitness in forum Excel General
    Replies: 7
    Last Post: 06-26-2015, 07:00 PM
  4. [SOLVED] Calculate 365/180/90/30 days from today date
    By DonW in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-02-2013, 09:44 AM
  5. Replies: 4
    Last Post: 01-17-2013, 01:23 PM
  6. create a macro to alert me if today's date is within 5 days of expected delivery date
    By ashmcclure in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 09-25-2008, 05:51 PM
  7. how to calculate a date .. say 34 days from today
    By shaunl in forum Excel General
    Replies: 5
    Last Post: 07-13-2005, 09:38 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1