Hello - I'm trying to find an elegant formula to show a value if it falls between one of multiple date ranges. See the attached Excel.
I have a number of clients, each of whom has multiple periods where users can sign up - see the first tab. In the second tab, I want to show the sign-ups per day for a given day if that day falls within one of the multiple date ranges in the first tab.
I know I could use an IF/AND formula for each date range, but I will need to easily be able to add date ranges, and so I'm wondering if there is a more elegant way of doing it.
Thanks for your help.
Bookmarks