RebelAlley
New Member
- Joined
- Nov 29, 2017
- Messages
- 3
I'm having an issue with my formula. What I want to do is count the number of times a date is in between 2 dates. I have a list of people and days they took off, each day is in a separate cell and each person is one row. I'm trying to string together multiple rows for my range. On another tab I have a column for the date at the beginning of the week (A) and the end of the week (B). This is what it looks like right now:
=SUM(COUNTIFS(INDIRECT({"Holiday!B16:BP16","Holiday!B29:BP29","Holiday!B41:BP41"}),"<="A2),(INDIRECT({"Holiday!B16:BP16","Holiday!B29:BP29","Holiday!B41:BP41"}),">="B2))
Excel won't even accept this as a formula and my head is starting to hurt thinking about it.
I also tried this which isn't working - it is picking up dates that are after the end of the week =SUM(COUNTIF(INDIRECT({"Holiday!B17:BP17","Holiday!B30:BP30","Holiday!B42:BP42"}),">="&[@End]-"6"))
=SUM(COUNTIFS(INDIRECT({"Holiday!B16:BP16","Holiday!B29:BP29","Holiday!B41:BP41"}),"<="A2),(INDIRECT({"Holiday!B16:BP16","Holiday!B29:BP29","Holiday!B41:BP41"}),">="B2))
Excel won't even accept this as a formula and my head is starting to hurt thinking about it.
I also tried this which isn't working - it is picking up dates that are after the end of the week =SUM(COUNTIF(INDIRECT({"Holiday!B17:BP17","Holiday!B30:BP30","Holiday!B42:BP42"}),">="&[@End]-"6"))