Want to add 20 Leaves every year in an individuals account specifically on the date of his hiring in our company in two sets of dates
Cell A1 Date of of hiring : 01/07/1992 (Date format: dd/mm/yyy)
B2 C2 D2 E2 F2 (Answer Cell)
01/01/2017 30/04/2017 01/05/2017 29/06/2017 0
30/06/2017 30/07/2017 31/07/2017 20/12/2017 20
21/12/2017 20/06/2018 21/06/2018 01/07/2018 20
02/07/2018 30/10/2018 31/10/2018 02/07/2019 20
If the hiring date occurs between any of these two sets of date of any year F2 will return 20 or 0
I immensely searched the net for the answer but yet to find a solution for the problem looks unique. Will be glade if you can give me a solution.
Thanks in advance for the solution offered.