MaunishP
Member
Hi Team,
I would require a formula / dashboard where August we start our new year, where each employee is credited 2 leaves every month, now if any employee takes any leave in first month as per example Mr.A has taken 3 leaves in August now his leave balance should come -1, however rest employees havent taken any leave hence thier Leave balance should 2. This leave balance data should be carry forward every month in next sheet where each month 2 leaves are added and leaves are deducted if applied.
I am not able to carry forward leaves data every month and deducte if they have utlitized in any month.
Attached is file
Regards,
Maunish Patel
I would require a formula / dashboard where August we start our new year, where each employee is credited 2 leaves every month, now if any employee takes any leave in first month as per example Mr.A has taken 3 leaves in August now his leave balance should come -1, however rest employees havent taken any leave hence thier Leave balance should 2. This leave balance data should be carry forward every month in next sheet where each month 2 leaves are added and leaves are deducted if applied.
I am not able to carry forward leaves data every month and deducte if they have utlitized in any month.
Attached is file
Regards,
Maunish Patel