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