Hello Respected Experts,
The query is quite funny and complex but I have been asked by my director to resolve it by any means on URGENT BASIS.
In the attached excel:
Allowed Leave: 2 (Every month 2 leaves will be given)
Leave Taken for Jan: 3
Balance for Jan: -1
Hence, Simple Maths: Opening Balance for Feb should be (-1+2=1)
But my boss wants condition in which Feb month opening balance should be 2 even if previous balance is in negative (-1 for Jan). Hence, J5 should be 2. How can this be possible?
Please guide and help me ASAP.
Thanks and Regards,
Akash Sharma