I'm an extreme novice at this stuff so go easy!

I've got a holiday calendar for 6 people in my department at work, where
either 0.5 or 1 day may be booked in a cell for each working day of the year.
Each day has the julian day in the same column.

I need to do a sum for holidays taken (before the julian day has been
reached) and also for those that have been requested but haven't yet taken
place (ie after the julian day) but i'm struggling.

EG. every tuesday in Jan has 1 holiday booked (1 of these has taken place,
the other 3 are still to come. A calculation is required to add these
together.

This will need to be repeated for several people in the below rows on the
same table.

Thanks in advance.
Tom