cell entry expire

R

rbell

I'm trying to try to make a cell entry expire on a given date. It will
be used for a promotional discount that only runs for a set time
period. Anyone have a sugestion.
 
D

Dave Peterson

Maybe you can use a formula that puts the discount in (0 or whatever you want):

=IF(TODAY()>=DATE(2005,7,13),0,.15)

So when the date is July 13, 2005 or later, the discount is 0. If before, it's
15%.
 
R

Roger Govier

You could set your expiry date in a given cell, say A1
Set your discount as a % value in B1

Then use a formula such as
=IF(TODAY()>A1,1,1-B1) and use this as the multiplier of your price.
Changing the date value in A1 or the %age discount in B1 will then change
the cost of your products accordingly.
 
Top