+ Reply to Thread
Results 1 to 7 of 7

How to: dates & reminder datae based on another date's exxpiration

  1. 06-28-2020, 06:20 PM #1
    PieLam
    PieLam is offline
    Registered User
    Join Date
    06-23-2013
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2010
    Posts
    7

    How to: dates & reminder datae based on another date's exxpiration

    Hi!

    I know this is probably very basic to some of you ... I'm hoping to acquire some of your expertise for me. I'm a very casual Excel user. Even though I've been using it a long time, casually.

    Currently, I'm using MS Office 2010 Student Edition on Win10.

    I want to create a reminder date that is a week prior to an expiration date. Is this even possible?

    I'm thinking it is based on other tremendous feats that I've seen accomplished in Excel over the years.
    Reply With QuoteRegister To Reply
  2. 06-28-2020, 06:59 PM #2
    GeoffW283
    GeoffW283 is offline
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,616

    Re: How to: dates & reminder datae based on another date's exxpiration

    Here's one approach:

    PieLam.png

    In cell B2:
    =IF(A2 < NOW() + 7, "Reminder - expiration date is nearing!", "")

    Hope this helps
    Geoff

    Did I help significantly? If you wish, click on * Add Reputation to say thanks.
    If your problem has been resolved please select ?Solved? from the Thread Tools menu
    Reply With QuoteRegister To Reply
  3. 06-28-2020, 08:19 PM #3
    ORoos
    ORoos is offline
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    897

    Re: How to: dates & reminder datae based on another date's exxpiration

    Another option may be conditional formatting.
    Highlight column A from second row down.
    Conditional Formatting > New Rule > Use formula ...
    =A2>TODAY()-7
    Then set the format for the cells to a colour that suits.
    You then could apply multiple formatting, for example yellow if due in 7 days, orange if due in 2 days, red if passed due date...

    You could of course also combine it with Geoff's solution above.
    If your Question is answered; please mark it SOLVED. If you are happy with a member's solution, say 'Thanks' and click the 'Star' to Add Reputation.
    Reply With QuoteRegister To Reply
  4. 06-29-2020, 11:04 AM #4
    PieLam
    PieLam is offline
    Registered User
    Join Date
    06-23-2013
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: How to: dates & reminder datae based on another date's exxpiration

    Thank you both for the elegant solutions! I just knew I could count on this forum!
    Reply With QuoteRegister To Reply
  5. 06-29-2020, 11:20 AM #5
    PieLam
    PieLam is offline
    Registered User
    Join Date
    06-23-2013
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: How to: dates & reminder datae based on another date's exxpiration

    Sorry, Geoff. How do I access the thread tools menu? (I'm visually handicapped)
    Last edited by AliGW; 06-29-2020 at 11:22 AM.
    Reply With QuoteRegister To Reply
  6. 06-29-2020, 11:22 AM #6
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,414

    Re: How to: dates & reminder datae based on another date's exxpiration

    It's top right, but I have done it for you.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  7. 06-29-2020, 04:49 PM #7
    GeoffW283
    GeoffW283 is offline
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,616

    Re: How to: dates & reminder datae based on another date's exxpiration

    Quote Originally Posted by PieLam View Post
    Thank you both for the elegant solutions! I just knew I could count on this forum!
    Thanks for the feedback and the reputation points
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Email reminder based on date
    By jak68 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-21-2016, 07:25 PM
  2. Sending email notification reminder from excel based on dates.
    By MCCranes in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-13-2014, 12:30 AM
  3. Sending automatic reminder based on date
    By kareem.mostafa87 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-24-2014, 11:29 AM
  4. Email a reminder notice based on a date
    By dakotajohn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2014, 01:21 PM
  5. Reminder based on Today's Date
    By cschoyer in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-22-2012, 03:38 PM
  6. VBA Automated Reminder Message based on Date
    By Carl Thompson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-02-2010, 09:11 AM
  7. Comparing Multiple Dates to Today - Due Date Reminder
    By TheMooCow in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-01-2010, 02:08 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1