If statements that look for a date range

B

Brian Roberson

Help!!! I am trying to look at an ActiveCell and determine
if it is in a certain date range from the current date to
180 days prior and then complete an action. Any
suggestions?
 
B

Bob Phillips

Brian,

You cannot look at the activecell with a formula as that would be circular.

You could use this in say B1

=IF(AND(A1>=TODAY()-180,A1<=TODAY()), "do something", "do something else")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top