Hi all,

I'm working on a leave management solution for my office and it
has 3 worksheets. The first one has the leave application data; the second
has the daywise breakup of available and approved leave slots while the
third sheet has the accrued leave for each employee.

The solution allows the employees to enter the start date and end date for
their leaves and then approves the leave based on two conditions - there
should be enough slots available on that day and there should be a positive
accrued leave balance for the employee.

The problem I'm facing here is that when an employee applies for leave on a
day when there aren't enough slots available, the formula for approval
returns a No. However, it becomes a No for all previous instances where
employees applied for a leave on that day.

What I want is that once a leave application is processed, the approval
formula for that application should stop recalculating. Is there any way this
can be done?

Thanks,

Sam