maheshanavkar
New Member
- Joined
- Oct 26, 2020
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Dear Sir
Please help beleow query
attached excel screenshot :
Condition 1 : Employee has work on 18/10 sunday so he can take off 3 days before 15/10 or 3 days after 21/10 ( i had updated two condition in data validation but below 2 condition pending
)
condition 2 : Employee working on 25/10 sunday so he can apply off from previous availed off to 26/10 - (means 11 days from availed previous off on 15/10 to 26/10 )
condition 3 : ifemployee does not working next sunday 25/10 but he worked on 01/11 so his previous off date aplicable 25/10(sunday) so he can apply off from 25/20 to 05/11 (11 days )
(upper all rules aplicable for all monthly sunday working)
Please help beleow query
attached excel screenshot :
Condition 1 : Employee has work on 18/10 sunday so he can take off 3 days before 15/10 or 3 days after 21/10 ( i had updated two condition in data validation but below 2 condition pending
Excel Formula:
condition 2 : Employee working on 25/10 sunday so he can apply off from previous availed off to 26/10 - (means 11 days from availed previous off on 15/10 to 26/10 )
condition 3 : ifemployee does not working next sunday 25/10 but he worked on 01/11 so his previous off date aplicable 25/10(sunday) so he can apply off from 25/20 to 05/11 (11 days )
(upper all rules aplicable for all monthly sunday working)