Expiration Date countdown

[Colin Hayes]

Hi

I have a small puzzle which I'm hoping someone can help with.

I have a Defined Name established in my worksheet as Expiration_Date.
This is a saved date for when the worksheet was first used.

In G7 , I need to have a countdown saying ' N days remaining'.
Effectively , on opening the workbook , it would subtract
Expiration_Date from the current date to give a whole number of days
between. It only needs to do this on each opening , and doesn't need to
monitor constantly.

Can someone help with a formula for this?

Grateful for any help.



Best Wishes

 

[John]

HI
Try this in G7: ( =Expiration_Date-cell that you have the current date ) and
format G7 as General not date.
Don't use the bracket around the formula. Dates are just numbers, so your
futur date minus todays date will give you
your answer if you format the cell as General.
HTH
John

 

[Colin Hayes]

=(expiration_date-today())&" days remaining"

Hi

OK thanks for that - it works perfectly first time. ^_^


BTW How would you show the date element in bold in this formula? Is it
possible?

I tried playing with the formatting but could not make this effect.



Best Wishes