Breadnjam18
New Member
- Joined
- May 6, 2021
- Messages
- 2
- Office Version
- 2019
- Platform
- Windows
Ok so Im trying to create a formula to calculate between some dates in excel
So have most of it but not quite all.
Basically what i need is if the years service is grater than 5 but less than 10 then add 1 (or result in 21) and if greater than 10 add two. I have half of the formula sorted as if its greater than 10 its adds two, but i cant figure out the between 5-10 part. here is what i have
=IFS(D6<=5, "20",D6>5<10,"21", D6>10,"22")
Start Date | Years Service | Std Holiday Entitlement | Result |
28/08/2018 | 2 | 20 | 20 |
So have most of it but not quite all.
Basically what i need is if the years service is grater than 5 but less than 10 then add 1 (or result in 21) and if greater than 10 add two. I have half of the formula sorted as if its greater than 10 its adds two, but i cant figure out the between 5-10 part. here is what i have
=IFS(D6<=5, "20",D6>5<10,"21", D6>10,"22")