Results 1 to 6 of 6

Date Countdown with Reference to Specific Cell?

Threaded View

Antligen Date Countdown with Reference... 06-25-2014, 04:44 AM
jwillis07 Re: Date Countdown with... 06-25-2014, 04:53 AM
Antligen Re: Date Countdown with... 06-25-2014, 06:12 AM
Pete_UK Re: Date Countdown with... 06-25-2014, 04:55 AM
aavins73 Re: Date Countdown with... 06-25-2014, 05:01 AM
jwillis07 Re: Date Countdown with... 06-25-2014, 06:22 AM
  1. #1
    Registered User
    Join Date
    01-20-2014
    Location
    london, England
    MS-Off Ver
    Excel 2010
    Posts
    49

    Question Date Countdown with Reference to Specific Cell?

    Hi,

    I have this formula counting down days until my next fire drill:

    =DATEVALUE("17/12/2014")-TODAY()&" days until next fire drill is due"
    However... Every time the drill is done I need to change the date in the formula for the countdown.

    I don't want to have to manually change this formula EVERYTIME I do a drill. Is there away instead of having:
    ("17/12/2014")-
    that I can have it reference a cell instead?

    Myinitial idea was a formula like this:
    =DATEVALUE(G10)-TODAY()&" days until next fire drill is due"
    (however this code doesn't actually work ...)

    Any ideas from the formula wizards out there?

    Kindest regards as always,

    Antligen
    Last edited by Antligen; 06-25-2014 at 04:45 AM. Reason: Correcting Grammar ;)

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Reference a date, then copy and transpose paste into a date specific location
    By nelmsd in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 02-26-2013, 03:30 PM
  2. [SOLVED] Specific countdown timer
    By ballan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-22-2012, 09:12 PM
  3. adding a countdown to a specific date and time to a userform
    By teacher_rob in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-15-2012, 10:30 AM
  4. Replies: 4
    Last Post: 05-13-2011, 02:05 PM
  5. [SOLVED] countdown days,hours,minutes,seconds to a specific date
    By jje2149 in forum Excel General
    Replies: 1
    Last Post: 06-01-2006, 08:50 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1