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

  • Thread starter Thread starter Mike
  • Start date Start 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
 
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

Back
Top