I need to create a personal leave tracking for my work.
The remaining leave(days) will carry forward to this year but will expired on end of March.
Before the expired month (end of March), my leave taken will deduct from the forwarded days from last year first, then only deduct from this year entitled days if it is not enough.
After March, if there are still remaining days (last year) it will be burn (0)
I've attached the file I created halfway, but got no idea on the formula.
Can someone have a look & help?
Thank you.
Bookmarks