# Working Days based on month

1. ## 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

2. ## Re: Working Days based on month

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.

3. ## Re: Working Days based on month

=WORKDAY.INTL(\$D\$5,ROWS(C\$8:C8)-11)
Try this one

4. ## Re: Working Days based on month

Hi

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

5. ## Re: Working Days based on month

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)

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1