Date Countdown with Reference to Specific Cell?

[Antligen]

Hi,

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

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

that I can have it reference a cell instead?

Myinitial idea was a formula like this:

Please Login or Register  to view this content.

(however this code doesn't actually work ...)

Any ideas from the formula wizards out there?

Kindest regards as always,

Antligen

[jwillis07]

Yeah you were almost right, just remove the DATEVALUE part...

=G10-TODAY()&" days until next fire drill is due"

[Pete_UK]

If G10 contains a date, then you can just have:

=G10-TODAY()&" days until next fire drill is due"

Hope this helps.

Pete

[aavins73]

pls try this. keep your date in G10 cell . You should also have the cell in number format.

Please Login or Register  to view this content.

[Antligen]

Thank you very much for your help!

So, what does DATEVALUE actually do in this instance then? Why would I not need it for this formula?

I'm still learning formulas on here so any chance to learn something really helps me.

Thanks again!

[jwillis07]

No problem.

I believe date value is for cells that have a date formatted as text although I've never had a need for it.