considerations:

columns/fields on the list -> work load reference no., hours, availability, date, allowance

work load reference no. such an incident ticket, change no. etc. is mandatory for allowances

comp-offs to be considered only if the date matches a holiday, or if the day matches saturday/sunday

formula:formula

note -> WEEKDAY(date,2)=6, 7 refers to saturday, sunday respectively; 2 refers to the date format

demo:demo