Hi all,

I am trying to calculate the total number of working hours per each week (1
through 6) of a given year.

Here is the structure of my spreadsheet:

Row 1 contains a heading for each month of the given year.
Row 2 contains a heading for each week of month (week #1 through #6)
Row 3, I need a formula or VBA code that automatically inserts the total
number of available business working hours per that week. Of course
excluding the federal holidays which I have created a named range for it in
the spreadsheet.

for example for the target year 2010, I should have the following values in
each week of the month:

January-2010:
WK #1 - 0 hours (note: 1/1/10 is a holiday)
Wk #2 - 40 hours
WK #3 - 40 hours
WK #4 - 32 hours (note: 1/18/10 is a holiday)
WK #5 - 40 hours
WK #6 - 0 hours

February-2010:
WK #1 - 40 hours
Wk #2 - 40 hours
WK #3 - 32 hours
WK #4 - 40 hours
WK #5 - 0 hours
WK #6 - 0 hours

etc...for the remaining months.

I have tried many htings but I am nt able to get this working. Can any one
please help? Thanks very much.

Please show what you've tried so far.

Barb Reinhardt



"LABKHAND" wrote:

Hi all,

I am trying to calculate the total number of working hours per each week (1
through 6) of a given year.

Here is the structure of my spreadsheet:

Row 1 contains a heading for each month of the given year.
Row 2 contains a heading for each week of month (week #1 through #6)
Row 3, I need a formula or VBA code that automatically inserts the total
number of available business working hours per that week. Of course
excluding the federal holidays which I have created a named range for it in
the spreadsheet.

for example for the target year 2010, I should have the following values in
each week of the month:

January-2010:
WK #1 - 0 hours (note: 1/1/10 is a holiday)
Wk #2 - 40 hours
WK #3 - 40 hours
WK #4 - 32 hours (note: 1/18/10 is a holiday)
WK #5 - 40 hours
WK #6 - 0 hours

February-2010:
WK #1 - 40 hours
Wk #2 - 40 hours
WK #3 - 32 hours
WK #4 - 40 hours
WK #5 - 0 hours
WK #6 - 0 hours

etc...for the remaining months.

I have tried many htings but I am nt able to get this working. Can any one
please help? Thanks very much.

Barb,

I am not sure where to start...I have even confused myself since I keep on
trying different things. TO be honest, I am not sure where to begin to tell
you what I have tried. Sorry!

"Barb Reinhardt" wrote:

Please show what you've tried so far.

Barb Reinhardt



"LABKHAND" wrote:

Hi all,

I am trying to calculate the total number of working hours per each week (1
through 6) of a given year.

Here is the structure of my spreadsheet:

Row 1 contains a heading for each month of the given year.
Row 2 contains a heading for each week of month (week #1 through #6)
Row 3, I need a formula or VBA code that automatically inserts the total
number of available business working hours per that week. Of course
excluding the federal holidays which I have created a named range for it in
the spreadsheet.

for example for the target year 2010, I should have the following values in
each week of the month:

January-2010:
WK #1 - 0 hours (note: 1/1/10 is a holiday)
Wk #2 - 40 hours
WK #3 - 40 hours
WK #4 - 32 hours (note: 1/18/10 is a holiday)
WK #5 - 40 hours
WK #6 - 0 hours

February-2010:
WK #1 - 40 hours
Wk #2 - 40 hours
WK #3 - 32 hours
WK #4 - 40 hours
WK #5 - 0 hours
WK #6 - 0 hours

etc...for the remaining months.

I have tried many htings but I am nt able to get this working. Can any one
please help? Thanks very much.