Hi Coda Community,
I have to lean on your help again!
So I am making a booking system.
I use net working days to calculate how many days a booking lasts for.
The problem is I am booking in teachers who only work during term time.
I have a seperate table that contains the term time dates.
Can I create a formula that use net working days but discounts any of the days for half term.
What I am trying to achieve is being able to calculate the total cost of a booking by counting all the booked days?
A teacher is booked from September to December
They work every weekday but from Monday 26th October to Friday 30th October its half term - so they aren’t needed in school so I don’t want to count this in calculating the booked days.
Another problem I want to solve with my booking system is that I pay teachers weekly.
If I have a booking that lasts several months, can I work out what a teacher is owed each week without having to have seperate weekly bookings for the duration of the booking?
I am working on something that looks at the week numbers during the duration of the booking but struggling to get it to work!