Good afternoon,

I'm trying to get a cell to display either "HIT" or "MISS" based on the value of another cell.

So, I currently have A8 set as;

=IF(AE8="","",AE8-O8)
This is the difference in days between two dates

I would like to set B8 to be the HIT or MISS cell.

HIT should be displayed when the value of A8 is within -7 to 7

MISS should be displayed when the value is greater than or equal to -8 ... OR .... greater than or equal to 8

So basically, I have a seven day window either side of the target date for the value to show HIT - anything outside of the target window needs to show MISS

Any assistance would be very gratefully appreciated