Can you provide an example?

Sounds like you will somehow need to use either the NOW() or TODAY() formula.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Kesbutler" wrote:

I need to create a formula based on date. I need to creat a calcualte to
include other cells only if they meet certain date requirements. The cells
will meet the requirements a certain period of time then will need to be
removed from the formula. I am trying t automate the worksheet so I don't
have to update it once a month to exclude the previous 4 weeks. How can I do
this?