A | B | C | D | E | F | G | H | I | J | K | L | M | |
1 | Start date | Year End of 1st Year | Hol Year start | Hol Yr End | Accrual Start Date | Today | Total Days in Service | Accrued Holiday | Holiday Entitlement | Taken Holiday Days | Taken Half Holiday Days | Taken Holiday Days | Remaining Holiday Days |
2 | 20/11/17 | 31/03/2018 | 31/03/19 | 20/11/17 | 24/04/19 | 520 | 20 | 0.0 | 0.0 | 0.0 | 20.0 |
<tbody>
</tbody><colgroup><col><col><col span="2"><col span="3"><col><col span="6"></colgroup>
=IF(OR((H3<((C3-B3)+1095)),(J3),0),IF((H3>((C3-B3)+1095)),(J3+1),0),IF((H3>(C3-B3+1460)),(J3+2),0))
So I am now trying to get this formula to work correctly.
The second and third IF calculations work when the number is over the amount and it adds 1, 2. But I can't seem to get the first bit correct to show that when H3 is is less then (C3-B3)+1095 then it just needs to show J3