I have two columns that have the start and end date of the corresponding activity. Across the top of my spreadsheet I have Week ending dates. What I would like to do is check and see if my week ending date falls in that start and end date range. If it does, I want to put a number "1" in a corresponding cell. So if E4 is between the dates in C4 and D4, then put a "1" in F4. If not, leave it null.
Bookmarks