Hello,
Attached is a sample data sheet. It has three columns: Site, Date Started, Date Visited. I am from the UK, so date format is dd/mm/yyyy.
I want to count all occurrences where the Date Visited is within a defined period and within 6 months of the Date Started.
Using the sample data, I'd like to count number of rows where Date Visited was between 01/01/2018 and 30/04/2018 and Date Visited was within 6 months of the Date Started.
I think it can be done with COUNTIFS and EDATE functions... but it's just not happening for me, please help!
Cheers
Bookmarks