I would like to create a table to count and assign 25 holidays per year to employees.
I’ve managed to create a formula that sums holidays excluding national holidays and weekends but I would like to create a field called “Days Left” with a formula that calculates the holidays left out of a 25 days yearly allowance. That would mean I would have to calculate something like this:
25 (days) - (minus) Sum of Holidays taken up-to-date from the period 1st Jan 2020 to 31 Dec 2020
Thanks! That worked just fine, although I find it a bit fuzzy to create two tables for one function…
My last question would be if there is a way to have this formula renew the 25 days of holidays per year automatically. To demonstrate, I’ve added holidays spanning two different years and it keeps adding, so it messes up the function of the table.
Hi, I will have to do a fair amount to remove everyone from mine.
To give you a rough idea I have:
List of Employees and start dates plus any other info you want.
Employee Leave Summary table
This table has a Record (row) for each “Leave Period” for each Employee. So If someone’s holiday runs from January 21 to January 22 then this would have one Record and would be linked to the Employee.
Leave period start
Leave period end
Time worked (aka if they are part-time how much time they work)
Annual Leave Pro-Rata
Annual Leave (Calculated based on amount of year worked and part-time)
Public holiday days
Bookable leave (Leave available to be reserved)
Leave still available
There would then be a record for each period booked off, linked to a “Employee Leave Summary” Record.
It would contain, the start date, end-date, number of days off and perhaps whether it’s been approved etc…