Closed Thread
Results 1 to 2 of 2

Creating formula to return notification of date

  1. #1
    Registered User
    Join Date
    11-14-2022
    Location
    Indiana
    MS-Off Ver
    Microsoft 365
    Posts
    2

    Creating formula to return notification of date

    I am trying to create a document that I can utilize throughout our agency that will automatically update when a specific Evaluation is due based on the date of the most previous. They are due each year and I want for it to return "DUE" when the date is approaching within 7 days and "OVER DUE" when the date has exceeded the date.

    Any help is appreciated.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Creating formula to return notification of date

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: link to be added here

    https://www.excelforum.com/excel-for...on-a-date.html
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Creating email notification within excel workbook with VBA
    By DarthVegetaPool in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2022, 09:44 AM
  2. Replies: 4
    Last Post: 03-21-2018, 09:25 AM
  3. Creating something like notification
    By Muz1993 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2017, 11:05 AM
  4. [SOLVED] If and Date formula notification for future dates
    By Wikster7 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-10-2015, 05:30 PM
  5. Replies: 2
    Last Post: 01-08-2014, 01:06 PM
  6. [SOLVED] Creating a formula to lookup a cell and return date relevant to period
    By Marcel Coetzee in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-13-2013, 11:48 PM
  7. Notification for due date
    By Arjuncv in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-20-2013, 09:24 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