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

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


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=49940

In article , Pecoflyer
writes

=(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

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" wrote in message
...

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