Create List of Working Days

Hi,

I am trying to create a calendar of working days in a month in range G5:G35 in the attached workbook.

A day is considered a working day if :

a) It is not a Sunday; and
b) It is not a declared holiday appearing in range C4:C12 in the attached workbook.

Also, a date for the next month should not appear in this range. You can see that I already have spillover to the next month appearing in my list.

Can someone help with the formula in range G4:G35 to achieve this ?

NOTE: I have taken upto G35 to ensure that the month with minimum of Sundays and no declared holidays will get covered and and the entire month get covered in this range.

Any help will be greatly appreciated

Anand

See attached. Column J & K.

Does this work for you?