Absence formula

[Bryan De-Lara]

I've already posted this, but it was hidden in someone else's messages and I
didn't want it to be missed. Sorry if it confuses.

I have a column A5 to A2936 with the date starting 01-Jan-2008 to
10-Jan-2015.
Column B5 is the days of the week.
Column C5 is the working days numbered 1 to 5, missing week ends and public
holidays, non working days up to 254, then the working year starts again at
day 1 for another year and so on.
What I need to do is work out the absences. From another sheet in the
workbook I have the data coming across to give the number of people employed
and the amount of absences. I have the formula for working it all out. The
problem I am having is getting the data from column C into the cell where
that data completes the formula.
I have tried various formulae including =NOW()*(A!C6) & TODAY formulae but
don't seem to be getting very far. I need to know the number of working days
as soon as the date changes, or when it is opened.
Any help would be greatly appreciated. I am learning but at my age the
retention is harder.

Bryan.

 

[TomPl]

See you other post.