Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Absence formula
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Absence formula
See you other post.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace numbers to 1s and 0s for presence/absence | Excel Discussion (Misc queries) | |||
Help with Absence sheet formula. | New Users to Excel | |||
Employee Absence Schedule for 2007? | Excel Discussion (Misc queries) | |||
Employee Absence Schedule Template | Excel Discussion (Misc queries) | |||
how do I do a day to day holiday and absence chart | Setting up and Configuration of Excel |