If statements that look for a date range

  • Thread starter Thread starter Brian Roberson
  • Start date Start date
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?
 
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)
 
Back
Top