Employee Leave Calculation

Originally Posted by Phuocam

Or try ...

=MIN(30,IF(TODAY()-E3<270,0,INT((TODAY()-E3)/30)*2.5))

This formula is equivalent to =MIN(30,2.5*QUOTIENT(C1,30)*(C1>=270)) where C1 is TODAY()-E3 as I say in post #2
So you can use =MIN(30,2.5*QUOTIENT(TODAY()-E3,30)*(TODAY()-E3>=270))

Formula:

=MIN(30,2.5*QUOTIENT(TODAY()-E3,30)*(TODAY()-E3>=270))