stathis1234
New Member
- Joined
- Jun 29, 2018
- Messages
- 7
Hello,
I am working somewhere that i am entitled to 2 days off per week whenever i am taking 1 day off per week 1 day needs to be added to my annual leave whenever I am taking 3 Days off per week 1 Day needs to be deducted
so i am looking for a formula that will count in an array of 7 cells (days of the week) which already have data validation list with the following values In/Off/AL to extract or add accordingly to see my annual leave balance
for ex in the bellow week
3 days needs to be deducted from my annual leave as i am allowed to only 2
Mon IN
Tue IN
Wed OFF
Thu OFF
Fri OFF
Sat OFF
Sun OFF
In addition of that if the value AL can be deducted as well,
I will be very grateful
Thank you
I am working somewhere that i am entitled to 2 days off per week whenever i am taking 1 day off per week 1 day needs to be added to my annual leave whenever I am taking 3 Days off per week 1 Day needs to be deducted
so i am looking for a formula that will count in an array of 7 cells (days of the week) which already have data validation list with the following values In/Off/AL to extract or add accordingly to see my annual leave balance
for ex in the bellow week
3 days needs to be deducted from my annual leave as i am allowed to only 2
Mon IN
Tue IN
Wed OFF
Thu OFF
Fri OFF
Sat OFF
Sun OFF
In addition of that if the value AL can be deducted as well,
I will be very grateful
Thank you