Additional or lesser weeks in a month.

[thursday140]

Good morning,

I’m attempting to multiply, 40 working hours x the amount of weeks in a month. But each month can be different. Some months have 4 weeks while others have 3.5 weeks etc. How can I run a formula without missing any working days in a month?

Thank you,

[6StringJazzer]

Can't give an answer specific to your file without seeing your file but here is the idea. Rather than 40 x weeks, use 8 x days.

If you have the first day of the month in A1 (like 1/1/2018) then this formula will give the number of working hours. You can also add a list of holidays.

=8*NETWORKDAYS(A3,EOMONTH(A3,0))

If you have a list of dates for holidays you can add them like so:

=8*NETWORKDAYS(A3,EOMONTH(A3,0),Sheet2!$A$1:$A$11)

[thursday140]

Can't give an answer specific to your file without seeing your file but here is the idea. Rather than 40 x weeks, use 8 x days.

If you have the first day of the month in A1 (like 1/1/2018) then this formula will give the number of working hours. You can also add a list of holidays.

=8*NETWORKDAYS(A3,EOMONTH(A3,0))

If you have a list of dates for holidays you can add them like so:

=8*NETWORKDAYS(A3,EOMONTH(A3,0),Sheet2!$A$1:$A$11)

This is perfect!!

[6StringJazzer]

Glad to help! Thanks for the rep