I've just spent 3 days merging names, their division or department, location with the start and termination dates. There were a lot of start and term dates missing, so I just added a "?" for those rows.
Now, I'm trying to determine if they were active for a given month. I would like to type in the first and last day of the month on the first row on cells H1 and I1 and have the active column update. I have part of this, but still missing something in my formula for the "Active" column. I could use some help.
See attached
Bookmarks