Hoopsah
01-15-2009, 02:39 AM
Hi
I have attached a copy of a workbook that allows the user to input absence for a FTE.
Within the tab "Absence Worksheet" I have used NETWORKDAYS to work out how long an absence period lasts.
However, when it comes to reporting I have to tally up the figures per week.
Is there a way to save the data in weekly windows. i.e. if the absence period is from 05/01/09 - 19/01/09 instead of reporting 11 days it would report:
05/01/09 - 09/01/09 - 5 Days,
12/01/09 - 16/01/09 - 5 Days,
19/01/09 - 19/01/09 - 1 Day - Total 11 days
Hope that makes sense
Thanks for any pointers/help
Hoopsah
I have attached a copy of a workbook that allows the user to input absence for a FTE.
Within the tab "Absence Worksheet" I have used NETWORKDAYS to work out how long an absence period lasts.
However, when it comes to reporting I have to tally up the figures per week.
Is there a way to save the data in weekly windows. i.e. if the absence period is from 05/01/09 - 19/01/09 instead of reporting 11 days it would report:
05/01/09 - 09/01/09 - 5 Days,
12/01/09 - 16/01/09 - 5 Days,
19/01/09 - 19/01/09 - 1 Day - Total 11 days
Hope that makes sense
Thanks for any pointers/help
Hoopsah