Hi
In attached file im trying to calculate casual leave balance of each month based on carry forward basis from previous and next month. Used IF conditions but not worked. Each month having 2 CL's and will add automatically once date criteria match. I need the following
Example: Jan leaves should be deducted from 2018 balance leaves till zero. Feb leaves deduct from first 2018 balance(if any) then Jan balance then Feb balance.
In attached file im trying to calculate casual leave balance of each month based on carry forward basis from previous and next month. Used IF conditions but not worked. Each month having 2 CL's and will add automatically once date criteria match. I need the following
Example: Jan leaves should be deducted from 2018 balance leaves till zero. Feb leaves deduct from first 2018 balance(if any) then Jan balance then Feb balance.