List workday and holiday dates

coliervile

Well-known Member
Joined
May 19, 2006
Messages
724
Hello every one-

I'm working on a academic calendar and I need to list the dates, Monday through Friday, of all of the workdays and holidays from the start date. A class is 36 days long. For example if a class starts on October 1, 2014 it would end on November 10, 2014 counting the one federal holiday on October 13, 2014. I need to list the 36 workday date and the one federal holiday date. How can I go about doing this?

Best regards,
Charlie
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

coliervile

Well-known Member
Joined
May 19, 2006
Messages
724
Thank you FDibbins for looking at my question and your suggestion. I'm not certain in Networkdays will do what I want it to. I know the start date and that the curriculum is 36 days, I would not necessarily know how many holidays fell within the 36 days to add to the start date.
 

coliervile

Well-known Member
Joined
May 19, 2006
Messages
724
The NETWORKDAY function might tell me the number of days how can I take that number and automatically list those dates. From my example in #1 how can I list all of the dates from October 1, 2014 to November 10, 2014... 37 days that Networkdays would return?

Charlie
 

coliervile

Well-known Member
Joined
May 19, 2006
Messages
724
Good day everyone,

I still can't figure out how to do this.

If I know the start date is October 1, 2014 and the course is 37 day, including the one federal holiday on October 10, 2014, how can I automatically make a list of 37 dates, for Monday through Friday, including the start date.

Best regards,

Charlie
 

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
10,832
Office Version
  1. 2019
Platform
  1. Windows
Enter the start date, then use the fill handle to drag it down 40 rows (36 plus a few extra to allow for holidays).

After dragging down, click the auto fill options flag, then choose 'Fill Weekdays'

Assuming your list in in A2:A41, In B1 enter =IFERROR(VLOOKUP(A2,$K$1:$L$10,2,0),"DAY "&NETWORKDAYS(A$2,A2,$K$1:$K$10)) and fill that down also.

Note that in the example formula, K1:K10 contains a list of holiday dates, L1:L10 contains a list of the holiday names.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,788
Messages
5,524,879
Members
409,609
Latest member
Channingz

This Week's Hot Topics

Top