# Need to create a List of Dates that will Exclude Weekends and Holidays Automatic

1. ## Need to create a List of Dates that will Exclude Weekends and Holidays Automatic

i want to create a list that will allow me to put a date on A1 and the A2,A3,A4,A5,A6 Ect... show the next date. I use the Formula =A1+1 to give the next date. So i would like to do that but have it when the date falls on a Sat or Sun it will skip it and go to the Monday. or if a date fall on a Holiday (which i created a Separate Tab to make a chart of holidays im using. Columns A1-Date & A2-Description in the Chart) that it will skip it and go to the next week day.

For Example December 2014 Christmas falls on the 24th and 25th for days off for work and the weekend is the 20th & 21st so i want it to automatically do this.

Friday 12/19/14 (i will type this date im myself)
Monday 12/22/14 (This will run of the Previous date automatically)
Tuesday 12/23/14 (This will run of the Previous date automatically)
Friday 12/26/14 (This will run of the Previous date automatically)

Is this Possible

2. ## Re: Need to create a List of Dates that will Exclude Weekends and Holidays Automatic

Check this I hope this will help u

Bok2.xlsx

3. ## Re: Need to create a List of Dates that will Exclude Weekends and Holidays Automatic

Thanks but I`m not understanding it. Because every i add a new Holiday date or even a new date all it gives me is #value.

4. ## Re: Need to create a List of Dates that will Exclude Weekends and Holidays Automatic

Try this...

Data Range
 A B C D 1 Date Weekday Holidays 2 12/19/2014 Fri 1/1/2014 3 12/22/2014 Mon 7/4/2014 4 12/23/2014 Tue 12/24/2014 5 12/26/2014 Fri 12/25/2014 6 12/29/2014 Mon 7 12/30/2014 Tue 8 12/31/2014 Wed

A2 = user entered date

Enter this formula in A3 and copy down as needed:

=WORKDAY(A2,1,D\$2:D\$5)

Enter this formula in B2 and copy down as needed:

=TEXT(A2,"ddd")

5. ## Re: Need to create a List of Dates that will Exclude Weekends and Holidays Automatic

can u send me that file so i look that
i think the problem is date formatting, U entered mm/dd/yyyy format and that sheet has dd/mm/yyyy format (I m not sure about that) so please send me that file which showing #value error

6. ## Re: Need to create a List of Dates that will Exclude Weekends and Holidays Automatic

I just wanted to say thank you guys for helping me out. and thank you pwnyadav007 but Tony Valko showed me a way that worked. But i just wanted to say thanks for everyone input. Have a good Day.

7. ## Re: Need to create a List of Dates that will Exclude Weekends and Holidays Automatic

You're welcome. We appreciate the feedback!

#### Thread Information

##### Users Browsing this Thread

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