Hi,
I am searching for a formula to COUNT how many times a date falls between a range, these dates are employee holiday dates and a want to show ultimately how many people will be off work on any given day. unfortunately the holiday entries are in the format of a start date and an end date, rather than a line of entry for each day they have booked.
in column N I have a list of dates, e.g. N1=01/01/2019, N2=02/01/2019, N3=03/01/2019 etc.
in column H I have a list of start dates, these are in random order,
in column I i have a list of end dates,
I want to say how many times does N1 (01/01/2019) appear in the range of H1:I100?
How many times does N2 (02/01/2019) appear in the range of H1:I100?
Etc. for all the dates in Column N
Any help would be greatly appreciated as I cant quite find anything tailored specific to this request,
Bookmarks