I am hoping to get some help with a formula I have not been able to master as yet.
This formula needs compare 2 dates and return text responses based on the result.
In Col A I have a forecast date
In Col B I have an actual date
I need the formula to return "Met" if the actual date falls "within" + or - 7 days from the forecast date. In other words met when the actual falls either 7 days before or 7 days after the forecasted date.
If the actual date is greater than 7 days before the forecast date I need it to return "Exceed"
If the actual date is Greater than 7 days later than the forecast date I need it to return "Miss"
I hope this makes sense. Thank you very much.
Bookmarks