Date Countdown with Reference to Specific Cell?

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

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.