1shivamkushwaha
New Member
Hi,
This is shivam,
This is a comp off sheet, and i want to automate it.
Comp off sheet is like if i work on holiday , i can avail a leave with in 60days for my comp off date.
1st row: actual date when we have holiday
2nd row: particular information about the holiday
3rd rod: last date to avail the comp off. or expiry date
4th row 2nd col: if (expiry date > today, 0, 1)
Now i want to know how many comp off i can avail today. I DONT WANT KNOW THE TOTAL COMP OFF. I JUST WANT TO GET THE COUNT OF ACTIVE COMP OFF. SO IN THE BELOW CASE EXPECTED OUTPUT SHOULD BE 1.
Explanation: Todays date is 15/07/2021, only this day is following between 5/28/2021 - 7/27/2021.
9/3/2021 is upcoming date so logically, to avail any comp off first i have to work on holiday then only i can take my comp off.
This is shivam,
This is a comp off sheet, and i want to automate it.
Comp off sheet is like if i work on holiday , i can avail a leave with in 60days for my comp off date.
1st row: actual date when we have holiday
2nd row: particular information about the holiday
3rd rod: last date to avail the comp off. or expiry date
4th row 2nd col: if (expiry date > today, 0, 1)
Now i want to know how many comp off i can avail today. I DONT WANT KNOW THE TOTAL COMP OFF. I JUST WANT TO GET THE COUNT OF ACTIVE COMP OFF. SO IN THE BELOW CASE EXPECTED OUTPUT SHOULD BE 1.
Explanation: Todays date is 15/07/2021, only this day is following between 5/28/2021 - 7/27/2021.
9/3/2021 is upcoming date so logically, to avail any comp off first i have to work on holiday then only i can take my comp off.
actual date | 1/1/2021 | 5/28/2021 | 9/3/2021 | ||
EMP ID | new year | abc | pqr | Expected output | |
Expiry date | 3/2/2021 | 7/27/2021 | 11/2/2021 | total remaing | avail |
shivam | 0 | 1 | 1 | 2 | 1 |
peter | 0 | 1 | 1 | 2 | 1 |
anjul | 0 | 1 | 1 | 2 | 1 |