Working Days based on month

Hi,

I would like the ability to list reporting days based on a month. E.g. if I was to select the month August if would list the dates that would apply to workday -10 to work day +X (where X denotes the last working day of the month).

On the attached spreadsheet on the tab “Work Day Calculator” I intend to state the month in D5. Where I need help is in the green cells to populate the date based on working days and holidays.

I have provided sample data for August and September in columns G:M

Can anyone help please?

Try this formula in E8:

=IF(WORKDAY($C$5,ROWS($E$7:E7)-11)>$E$5,"",WORKDAY($D$5,ROWS($E$7:E7)-11))

Copy down.

Hi

Is there anyway to include the holidays in also? e.g. in August the 8th and 29th are bank holidays.

Solved it - just had to reference the holiday sheet! Thanks all for helping!

Final formula: =WORKDAY.INTL($C$5,ROWS(C$8:C8)-11,,Holidays!$B$7:$B$19)