Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Calculate Employee Sick/Vacation time

Topic Labels: Formulas
617 1
Showing results for 
Search instead for 
Did you mean: 

Hi All, I have a great working time sheet base that calculates day totals and accrued vacation and sick time, but now I want to be able to subtract USED vacation and sick time from those accruals. I’m wondering if I can use check boxes to identify entries that are sick or vacation and the work those checked boxes into a formula that subtracts the identified records from the total accrued.

Here’s a screenshot:
Screen Shot 2020-11-04 at 4.37.09 PM

Thanks for any help you’ve got!

1 Reply 1


I am looking for a time sheet base that does exactly that. Would you mind sharing that base? I am not so good with formulas and have been trying to create this for 2 days now :cry: :grinning_face_with_sweat:

Any help would be so appreciated!