NBVAL on variable range
Solved
Taa66
Posted messages
2
Status
Member
-
Taa66 Posted messages 2 Status Member -
Taa66 Posted messages 2 Status Member -
Hello everyone
I need your help because I can't figure out how to solve my problem.
Basically, I have a schedule.
People are listed in rows and dates in columns.
If there is an "X", it means the person is working.
I want to count the number of working days per person from the beginning of May until today (A1), so my range will expand by one additional column every day.
Names of people from B3 to B10
Dates from 01/05/2022 to 30/05/2022 starting at C2.
Thank you in advance, hoping a solution exists.
Thanks everyone
I need your help because I can't figure out how to solve my problem.
Basically, I have a schedule.
People are listed in rows and dates in columns.
If there is an "X", it means the person is working.
I want to count the number of working days per person from the beginning of May until today (A1), so my range will expand by one additional column every day.
Names of people from B3 to B10
Dates from 01/05/2022 to 30/05/2022 starting at C2.
Thank you in advance, hoping a solution exists.
Thanks everyone
3 answers
Hello
A little example in the file
The formula
=COUNTIFS($C$2:$AG$2;"<="&$A$1;$C8:$AG8;"X")
A1 = TODAY()
C2:G2 the dates
C8:AG8 the row with the Xs
https://www.cjoint.com/c/LEmjWfqbHB4
A little example in the file
The formula
=COUNTIFS($C$2:$AG$2;"<="&$A$1;$C8:$AG8;"X")
A1 = TODAY()
C2:G2 the dates
C8:AG8 the row with the Xs
https://www.cjoint.com/c/LEmjWfqbHB4