Hello,
I have a spreadsheet where K8:NK8 equals each day of the year, 1/1/2017 to 12/31/2017. I9 (Start) and J9 (End) will each have a date. If the date in Row 8 is between the start and end date, I would like an X to appear in row 9. If not, I would like it to be blank.
FOR EXAMPLE:
START END 1/1/2017 1/2/2017 1/3/2017 1/4/2017 1/5/2017 1/6/2017 1/7/2017 1/8/2017 1/9/2017
1/2/2017 1/5/2017 X X X X
1/2/2017 1/8/2017 X X X X X X X
Can anyone help me with the formula for K9:NK9??
Thank you!
EDITED TO ADD: The above example does not appear as I typed it out, but the X's would be under the corresponding dates.
Bookmarks