How to Make a Tool 'EXPIRE' After a certain date

M

Mike

Hey EXCEL community:

Here's a challenge -> I am creating a tool on Excel that
I am going to send out to a large number of people. I
want the tool to 'EXPIRE' after a certain time (like 3
months). I have used the =IF(TODAY()>"A CERTAIN
DATE","EXPIRE",CALCULATION). However, if you set the
system clock back to the past, it will work again.

Any ideas how to make the tool not work after a certain
date? IE, link the time reference to an outside source,
etc.?

Regards,

Mike
 
B

BrianB

It would be possible to change the code with code on the first occasio
the date is exceeded - even if you just add "End"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top