+ Reply to Thread
Results 1 to 5 of 5

A formula to countdown dates given a time span that is specific

  1. #1
    Registered User
    Join Date
    08-03-2012
    Location
    Thatcham, England
    MS-Off Ver
    Excel 2010
    Posts
    2

    A formula to countdown dates given a time span that is specific

    Hi there, I need some help to find a formula that counts down days. I.e. if some attends specific training that has to be done annually or every two or three years, I need to be able to put in the date of the last time they attended and then a formula to countdown to show how long is left before they need to re-attend. Is there anyone who can help with this? It would be much 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,917

    Re: A formula to countdown dates given a time span that is specific

    try something like =today()-the-date-you-want-test or =now()-the-date-you-want-test
    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

  3. #3
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: A formula to countdown dates given a time span that is specific

    Try something like:

    =EDATE(A2,12)-TODAY()

    where A2 holds the date last tested
    replace the 12 with a cell ref if you prefer

  4. #4
    Registered User
    Join Date
    08-03-2012
    Location
    Thatcham, England
    MS-Off Ver
    Excel 2010
    Posts
    2

    Thumbs up Re: A formula to countdown dates given a time span that is specific

    [solved]
    Thanks to all for their help.

  5. #5
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: A formula to countdown dates given a time span that is specific

    You're welcome. Thanks for the 'star tap'.

    You haven't properly marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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