[TABLE="width: 919"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Start date[/TD]
[TD]Year End of 1st Year[/TD]
[TD]Hol Year start[/TD]
[TD]Hol Yr End[/TD]
[TD]Accrual Start Date[/TD]
[TD]Today[/TD]
[TD]Total Days in Service[/TD]
[TD]Accrued Holiday[/TD]
[TD]Holiday Entitlement[/TD]
[TD]Taken Holiday Days[/TD]
[TD]Taken Half Holiday Days[/TD]
[TD]Taken Holiday Days[/TD]
[TD]Remaining Holiday Days[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]20/11/17[/TD]
[TD="align: right"]31/03/2018[/TD]
[TD] [/TD]
[TD]31/03/19[/TD]
[TD]20/11/17[/TD]
[TD]24/04/19[/TD]
[TD]520[/TD]
[TD] [/TD]
[TD]20[/TD]
[TD]0.0[/TD]
[TD]0.0[/TD]
[TD]0.0[/TD]
[TD]20.0[/TD]
[/TR]
</tbody><colgroup><col><col><col span="2"><col span="3"><col><col span="6"></colgroup>[/TABLE]
=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
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Start date[/TD]
[TD]Year End of 1st Year[/TD]
[TD]Hol Year start[/TD]
[TD]Hol Yr End[/TD]
[TD]Accrual Start Date[/TD]
[TD]Today[/TD]
[TD]Total Days in Service[/TD]
[TD]Accrued Holiday[/TD]
[TD]Holiday Entitlement[/TD]
[TD]Taken Holiday Days[/TD]
[TD]Taken Half Holiday Days[/TD]
[TD]Taken Holiday Days[/TD]
[TD]Remaining Holiday Days[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]20/11/17[/TD]
[TD="align: right"]31/03/2018[/TD]
[TD] [/TD]
[TD]31/03/19[/TD]
[TD]20/11/17[/TD]
[TD]24/04/19[/TD]
[TD]520[/TD]
[TD] [/TD]
[TD]20[/TD]
[TD]0.0[/TD]
[TD]0.0[/TD]
[TD]0.0[/TD]
[TD]20.0[/TD]
[/TR]
</tbody><colgroup><col><col><col span="2"><col span="3"><col><col span="6"></colgroup>[/TABLE]
=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