Using Today()- 730 or Today()-182 works if close is OK, otherwise more involved date calculations will be needed.