Solved: Save dates for weekly figures

[Hoopsah]

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

[Bob Phillips]

Your monthly absence calculation fails if the absenc goes over a month end.

I would do it with VBA.

[Hoopsah]

Hi Bob,

Fantastic!!

Once again, this works perfectly, thanks for your help.

Gerry

[Hoopsah]

Hi Bob,

I know this is something I should probably know by now, but, when I copy the code over to my actual workbook and try to run it, I get an error message "424 - Object Required" and it stops at line: LastRow = .Cells(.Rows.Count, .Range("StartDates").Column).End(xlUp).Row

[Bob Phillips]

Gerry,

I changed the codenames of the sheets in the sample workbbok. I changed Sheet1 to wsAbsence, it is probably the only relevant one.

[Hoopsah]

So would I just change that to the sheet name ???

Sorry if I'm being dumb here

[Bob Phillips]

No, in the VBIDE, change the codename from Sheet1 to wsAbsence.

Take a look in the book I posted by looking at the worksheet objects in the Project Explorer.

[Hoopsah]

Ahh! Got You.

Cheers Bob, I have changed the name and it works fine now.

Thanks Again

Gerry