Dates auto populate

[Bazola]

Hi All

I have a spreadsheet for which I need it to do the following:

I have populated all weekdays into a separate sheet, and then also added in the bank holidays until 2025.

Now, I need it to automatically fill in the working days only into another sheet. So for example, a dropdown box in Cell A2, which would lookup against the months column in another sheet. Based on selecting this month, it would then automatically fill in Cell B2, D2, F2, H2, etc. with the correct working days from the other sheet.

The main sheet basically has to have all the working days listed for that month, in it. Then when I choose february 2019 from the dropdown, it looks and pulls the date for february 1st for example, then the next box would be 04/02/19

Your help would be appreciated.

 

[Panda514]

Hello, I'm not sure how to have it pull in a list of the work days, but I do have a suggestion while you are waiting for someone else to help you. You said you populated all weekdays into a separate sheet, so I'm thinking you could add a column on that sheet for the month and column that says holiday. Then you can filter on the month you want and filter the holiday column to blank. Or you can do something similar by using a pivot table.

Here is a picture of my example: https://postimg.cc/K17mKdRf

 

[Bazola]

thank you. I will look into it