This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi there,
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 ...
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 hol...
Thanks for your response.
I tried both but neither worked.
It does work for a single line / record, but won’t add up all holidays as employees take them.
See image below to illustrate:
