Expiration Date countdown

  • Thread starter Thread starter Colin Hayes
  • Start date Start date
C

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
 
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
 
Pecoflyer said:
=(expiration_date-today())&" days remaining"
Click to expand...

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
 
Back
Top