Employees are selected in their corresponding shift on each month tab in a dynamic calendar See 092022 tab in my example:
I want Pemanence tab will be able to retrieve automatically the values in the good current month tab based on TODAY's and TOMORROW's dates as I filled manually the values here :
I share with you my work as I need your help https://docs.google.com/spreadsheets/d/1zMgnIVAy71M_LX7VMs2IqnBgxO4eVZhatNkfjh0OSEw/edit?usp=sharing
Thanks in adavance