Here is my dilemma,
I need to know how many dates in a range fall between 2 dates.
For example, how many of the dates listed below fall between 11/4/2019 and 12/31/2019:
I am trying variations of countif functions I see posted elsewhere, but with no avail.Please Login or Register to view this content.
I named the date range above to "PAY_PERIODS", and the locked cells in the formula below are going to be the start and end dates.
The formula does not work if the range is 1/1/2019 to 12/31/2019.Please Login or Register to view this content.
Any help is appreciated,
Bookmarks