Make a Gantt Chart in Excel - Part 2: Working with Work Days

[@biagiogugliotta]

This series is absolutely fabulous! Thanks for all the information and for helping me develop my Excel skillset!

[@MeganMainwaring]

This and your last video are among the most useful things I have ever seen. Thank you.

[@MoonLiteNite]

In just 21 mins of excel videos from you, i think i have learned more than i have in 24 hours of all other youtube videos :D

[@vertex42]

Excellent! Thanks for the feedback.

[@amyharrell5258]

Let me reemphasize how great these videos are. I'm going to have my 1:1 with my director next week and blow her mind with what I'm putting together for project management. Thank you so much. Now back to watching the next video and seeing what's next.

[@HectorRiveros07hjrc]

I'm grateful what I learned on this video. thanks a lot.

[@matthewopahsulon4678]

Very impressive! The tricks are super cool....

[@joshtaton8986]

Between this and the first video, you are the best teacher on this subject ive seen. I took a construction scheduling course for an entire semester at a major university, as well as an excel course for an entire semester, and had I had you as a teacher I would have gone to class more! Thanks for your content and I appreciate you posting these, this has helped me out a ton as I get back into this business.

[@vertex42]

Thank you! :-)

[@kerenklein14]

Thank you so much! I learn a lot !!

[@rafaabarood6060]

One of the most beautiful programs .. I salute you

[@dcp15121980]

Hello Excel God. I wish I got this information long time back, probably 2019 or even earlier. Your videos are very very very super duper useful and resourceful.

[@jessjohnson6880]

This was very helpful. Thank you.

[@843292]

You're ghantt chart videos are the best! Very easy to follow... really top notch! Thank you!

[@scottymac734]

These Excel Gantt Chart videos (and workbooks) are truly amazing. I'll be adding hours to the respective resource-per-day and will need to figure out how to only subtotal their remaining hours from the start of current week, forward (excluding totals for prior weeks). But these instructive videos and templates tremendous.

[@ivanphillips1146]

Great videos with fantastic info....ill keep watching...

[@hanabro1912]

Really insightful and useful! big thanks for your video

[@gingerharmon1457]

These are great videos, thank you so much!! I have learned more from your 4 short videos than hours in advanced classes.

[@UrbanSeedling]

You are a magician!

[@katherineparra2126]

Honestly thank you for this amazing work!

[@lcg_wormtrader83]

Cool! the gantt chart is getting fabulous. The solutions given to the problems are teaching me soooo much.

[@vertex42]

Part 3 being published tomorrow!

[@aakashchaudhary3014]

Boss u r great ...

[@haninawaya9967]

That was amazing, thanks

[@hakandemir6286]

Thank you you are great

[@coolmonkey619]

Thank you thank you so so much I love you

[@RahulGupta-ig9gv]

woah .. this is high level stuff but interesting and addictive as well. Great video.

[@tohireron386]

Thank you. Great

[@jorper98]

Great videos and excellent tips! Learned a lot - and I am pretty good with Excel :-) Thank you!!

[@mehdihammadi6145]

Very well done, Thank you for sharing

[@julmaliahiyal2429]

I Love it!

[@pirata13]

already watched part 1 - loved it! hope you have more excel videos to watch

[@shubhamsahai2492]

Thank you for this great video!

[@nareshkantha]

superb .....

[@KhademalUmmah]

This is great, thank you so much. All of it worked well, except for the worked days conditioning formula. It kept shadowing for me different days of the week instead of the weekend. I do not know why! Can i get some feedback please!

[@klemenpotocnik5261]

Hi, thanks for the templates you offer. Please let me know how to add a new phase most easily. I really appreciate any help you can provide.

[@ericcaron5654]

amazing , exactly what I was needed, you are my today hero's :)

[@kamalam29]

thank you sir

[@adamsurya399]

thanks sir

[@ranjitselva]

Very good 👍.. how to make sure weekend and holidays are not taken as working days

[@priscillanunes7643]

Hello, your video is amazing! Thank you very much for sharing your knowledge. Is there a way to add deliveries to the Gantt chart and show it in the graph? Thanks.

[@ALEXIS-kv3cn]

For those of you who have struggled with removing the purple from the empty rows the equation is =AND(task_start"",G$5>=$D7,G$5

[@vladfodor2459]

I got stuck at this for half an hour. I taught all was lost, then said let's look at the comments maybe someone had the problem. Thanks a lot

[@kerenklein14]

THANK YOU!!! 😰

[@elp2557]

This got me past the error and then removed ALL of the purple bars! :|

[@cboisj]

Wow! I am amazed...great job!

[@csgbr-t4j]

Hi There! after I tried to solve an exel problem I found your chanel and really like the way you explain how to use exel in a higher level. I thought I was on a good way to solve my problem but now I’ve completely lost in formulas. Hope you can help me out of this: Imagine the same time line (gannt chart) like you have, that contains days in row from left to right. And the rows below each other for countries, no tasks. Each country has their own holidays what collected on a separate work-sheet (just like you did with holidays), like: A B 1 Hungary 08-Aug 2 Hungary 23-Oct 3 USA 4-July etc… What I tried is to indicate the holidays in the calendar part for each country using “conditional format”, but no luck so far. :( Tried to mix vlookup and match (might be this isn’t the best formula) but the best result was indicating the first holiday/date and no more. What would you suggest? Thanks in advance and have a nice one! Best, Gabor

[@memebaba2115]

Hey there, I will be delighted to know how you managed this situation 7 months ago it will be helpful to upskill for me and yes one more thing is learning Excel scheduling is a good choice as a part time or gig for a college student.

[@Jonesey96321]

Thanks for the video - brilliantly delivered I have added a column for assigned to - some of the people assigned to have days off during the week I.e Wednesday. How do I link specific people to days off and then have their colour bar take these days into account when calculating the working days to complete? Thanks

[@vertex42]

Might need a separate list of days off for each person ... not trivial, and I don't have an example of that to point you to.

[@Jonesey96321]

@@vertex42 thanks for the response... So I’ve added the list of days off for people onto the holidays dates tab and have created a custom data field for each agent (2) but I was unsure how to add this into the existing formulas to have the blue hazed colour code for each person on day off and then the Gantt chart colouring to extend beyond these days for end date. Any support would be appreciated

[@jenskautler]

Thanks for the great video. I do have one questions: I would like to add a planned date and a real achieved date and show this in the chart to give full transparence of a project. How would I do this?

[@rm8168]

You have done a great job with this video showing how to apply some very creative solutions to create a very useful Gantt chart. Thank you. I am wondering how when given complex projects with multiple milestones how we can accommodate/reflect multiple dependencies for a specific task, and how to dependencies can be reflected within the I Gantt chart? I'm looking forward to your next video. These have been very useful.

[@vertex42]

The Pro version lets you specify the WBS for up to 3 predecessors (with a formula that calculates the start date based on those references), and therefore the WBS is displayed in those columns as a reference. Without VBA, I don't know of any way to show visually (with connector lines) the dependencies between tasks in the gantt chart itself. For that type of thing, I would probably recommend using specialized PM software.

[@vertex42]

~~~~~ Q&A for this video ~~~~~ I've already had one question related to this video, so I'll use this comment as a place for Q&A. For those having an issue with Excel becoming very slow, see my note about 4:30 below. Question: How do you change the chart to show weekly or monthly intervals? Answer: Watch Part 3 - kzbin.info/www/bejne/fYWXlqiQnb-bh80 2:25 Question: Why do you subtract one from work days when calculating the End Date? Answer: The task is 4 work days: 11/4, 11/5, 11/6, 11/7. If we ADD 4 workdays to 11/4, then the end date would be 11/8, so that's why we have to subtract one, because the start date is included as one of the work days. 4:30 Make sure that when you create the holiday_dates range that you don't select the entire column. Only make the range as long as it needs to be. Don't use $A3:$A500000 for example. The NETWORKDAYS function is not very efficient if you have a long list of dates for the holidays argument. Using $A3:$A500 shouldn't cause too much of a slow down, but like I mentioned in the video, a dynamic named range for holidays_dates is useful in this situation: =Holidays!$A$3:INDEX(Holidays!$A:$A,MATCH(1E9,Holidays!$A:$A,1)) 8:47 Correction: I know I said that Color Coding would be the next video, but I needed to create the dynamic display first (which modifies the conditional formatting rules) before adding a bunch of new rules for the color coding. Stay tuned for Part 4.

[@shivamkathir3592]

Thank you so much for your effort. The data bar is not changing if the value less than 50%. I need to show the value even if 1 %. Could you help me on this?

[@maherkeden]

I love you

[@TurkerSaliji]

Hi, excelent video. Is there an easy way to make the chart duration only to cover months and maybe weeks only?

[@patriziavitale2904]

Thank you for this fantastic video! I get an error when I type in the formula =IF(OR(D12="",F12=""),"-",WORKDAY(D12,F12-1,holiday_dates)) and then paste it down in the same column. I have correctly defined the holiday_dates range in the "Holidays" workbook, so I can't find what I am doing wrong.

[@kalynwillis8582]

When you deleted the Display Week Row, what did you change about the H5 cell? That references the Display week and the scroll bar is linked to that as well. When I delete that row my entire algorithm messes up. I may have just missed that in the video and can't find it. Can you help me out?

[@nitinchakkera9325]

This is really a fantastic video. But i have one important question. When we change the progress %, it reflect considering the weekends or holiday list cells as well in Gantt Chart. Is there a way when we update Progress %, it should not consider weekend or holiday list in Gantt Chart? Such that when i update 50%, then the cells should consider without Holiday list and Weekend list. IF you could help me on this, i would be very greatful. Thanks in advance.

[@vertex42]

If you want it to consider weekends/holidays, use the WORKDAY.INTL function. Otherwise just use math using calendar days.

[@Finnfine]

@@vertex42 Where in the conditional formatting for the progress bar do we add in the WORKDAY.INTL function?

[@wennybuenaventura2073]

Hi Sir can I ask for a sample for selecting the month instead of display week? Thanks

[@jiovannialatorre5889]

I loved your video. It was very helpful in creating charts for projects at my job. I just had a question regarding if I'd need to add more rows to the chart. How would I add those easy and efficiently with all the formulas and formats?

[@vertex42]

Insert a row then copy the previous row down to fill in all formatting and formulas.

[@jiovannialatorre5889]

@@vertex42 thank you sir! Also if I would like to change the color of a specific row in the chart, how would I go about doing so?

[@gd6noob]

Your videos are awesome.. Learned lots.. Any chance you can create one about interactive dashboards with slicers?

[@vertex42]

:-) I'll consider it, but I only use pivot tables occasionally, so I doubt I'd have anything unique to say about pivot tables and slicers. There are some great websites that focus on dashboard reporting, though.

[@breakingbad582]

Vertex, thanks you so much for this video. I have a problem holiday issue for about work schedule. At construction works, there is not holiday every weekend in the world. there is a holiday biweekly.( According to change for country- Sunday or Friday). Could you please help me, how can i arrange formula biweekly holiday this excel template. Thanks in advance.

[@lovelyespinosa1760]

I have a concern. What if you have broken schedule, meaning 2 sets of dates for 1 task. How can you display the progress relative to the 2 set of dates?

[@NaturallySelected]

Inspiring!

[@annamariesoltren3222]

This video has totally changed my life as a PM - THANK YOU SO MUCH! However - my clients only use Google Sheets, which unfortunately doesn't recognize named ranges when input as a custom formula within conditional formatting. From my reserach, it seems like using the INDIRECT function as a custom formula within conditional formatting is the way to go, but I'm getting stuck despite my many efforts. Do you have a video or can you explain how to use the INDIRECT function as a custom formula within conditional formatting to 1) Remove the colored bars on title lines as shown in timestamp 2:40, and 2) dynaimcally exclude holidays I have listed in a separate “Holidays” tab shown in timestamp 4:15 in this video? Many thanks and appreciation!

[@vertex42]

You don't need to use named ranges in conditional formatting to make these Gantt charts work. Gantt Chart Template Pro contains a Google Sheets version that does almost everything the Excel version does. I use named ranges in these videos for two main reasons: (1) it shows people how to use named ranges and (2) it can make formulas easier to understand. The problem in Google Sheets is that you can't use references to other worksheets within conditional formatting rules. So, you have to use work-arounds. I use "helper" rows that contain the formulas I need and then use conditional formatting to refer to those results (and then hide those helper rows). To see this in action, you'd need to check out the GS version of Gantt Chart Template Pro - I don't think I use that technique in any of the free versions.

[@269211]

I try to mark the weekends like in your sample. But every time it chaange in a text format. For your information I work with Excel on Mac.

[@pen169169]

Very helpful chart,but it seems I could highlighting my holidays . Using the formula=match(date, holiday_dates,o) , need assistance

[@vertex42]

Likes like you used the letter "o" rather than the number zero "0" in the MATCH function.

[@miguelchristopherflorin6523]

hi sir, is this the correct formula? =AND(task_start'',H$5>=$D7,H$5

[@ahmedhaleem9802]

great tutorial. anyone knows how to change the weekend days to Friday and Saturday?

[@vertex42]

Use the WORKDAY.INTL and NETWORKDAYS.INTL functions and the weekend string "0000110". The weekend string starts with Monday. 0s are workdays and 1s are non-workdays.

[@PabloGonzalez-bc2xj]

Can you help me? I'm in the last formula to hide/show the weekends but it doesnt work... Value! Appears in every cell

[@peterbrown8601]

The gantt chart techniques are amazing and through them I am learning more about Excel. After adding the WORKDAYS formula in the workdays column, however, I have a problem with the appearance of the 'circular reference' warning when having entered a task start date and either tabbing or right arrow to the right. Is there a fix for this?

[@vertex42]

Yes, you'd need to figure out what you did to create the circular reference and correct the way you are creating your formulas. Do a Google search for "circular reference in Excel" to learn more about that.

[@johandegroot7791]

Another (positively meant) critique could be that you do not integrate "predecessors". For example : activity C can only start when activity B has finished a.s.o.

[@vertex42]

See Gantt Chart Template Pro for predecessors.

[@jamesroach9227]

incredible videos!! How can I create a 3 month bar (like the weekend bar) to change when the start date changes? would be great help so I can incorporate Monthly Goals! Many thanks the videos are amazing!

[@vertex42]

Not sure what you mean by "3 month bar (like the weekend bar)". I also don't know what you want to see with regard to monthly goals.

[@harikaavirneni4795]

Great explanation. Do you have any video to work with dependencies. The start date have to update based on end date of another task completion

[@vertex42]

3:24 in this video shows how to define a start date based on another task's end date. The page with the download for the simple gantt chart shows formulas for creating different types of dependencies www.vertex42.com/ExcelTemplates/simple-gantt-chart.html

[@erichekele8775]

I am having an issue with the progress bar in the gantt chart. It apparently is not taking into account the weekend. For example, a task starts on Fri, 11/1/19, is 4 work days, so it ends on Wed 11/6/19. When updating the progress bar,: 0%=no progress (correct), 25%=1 day/Friday (correct), 50%=3 days/Fri,Sat,Sun (incorrect, should also include Mon), 75%=4 days/Fri, Sat, Sun, Mon (incorrect, should also include Tues), 100%=all days (correct) It looks as though it is calculating the weekends incorrectly when applying the conditional formatting. The formula I have in my conditional formatting is: =1*AND(H$5>=task_start,H$5

[@ambienceprofessional5804]

how about if there is a predecessor on the task? anyways, great video. saving me a lot of time and resources. Thank you.

[@vertex42]

The Pro version includes a feature for defining predecessors. See the link in the description. It involves using a column for defining unique task ids and uses lookup functions based on the predecessor id.

[@engr.mithun7455]

Tnxxx u sir

[@reoncerejo5001]

Hello Sir, what if only Sunday is weekoff? How to highlight only Sunday instead of sat and Sunday?

[@lorrieandrews9290]

Just like the date change and the scroll bar changes, I want to set up where the list of tasks change with it For example, I put in a "task number" field under the display week field on this example. Instead of the the date changing horizontally, I want the tasks to change vertically along with the timeline bars. My dates would not change. Thanks

[@sodiksemaulsolahudin6249]

I use this formula for fixing the problem in a process for making workdays as an input but excel doesn't take it as a formula, why its can be happen =AND(task_start'';H$5>=$D7;H$5

[@mackyitaralde]

Thank you so much. One flavor, please. I would like to add an option where delays in the completion of the tasks from end date will be flagged and colored in the bars as well. Is there a way to do it?

[@vertex42]

There is a way. You would need to define the delayed end date in a new column. Then, add a new conditional formatting rule that is placed AFTER the existing one in the rule manager, that uses a similar formula as the purple bar except that the end date is the delayed end date. I don't have a video to demo that, but it does fall under a common topic of how to view planned vs. actual, so I'll consider it for the future.

[@mackyitaralde]

Vertex42 thank you so much. I tried it and it worked ;) really appreciate your time and effort :)

[@johandegroot7791]

This model assumes that start and end is known (deterministic) for all activities, which is not always the case. Usually, we have to estimate the time laps. A much used (easy statistical) way is to estimate (1 x pessimistic time + 4 times an expected time + 1 x optimistic time) / 6. Maybe an idea to integrate this into the chart to achieve a total time estimation of the complete project (incl. calculation of critical path method).

[@vertex42]

See the Critical Path Method / PERT template on vertex42.com. www.vertex42.com/ExcelTemplates/critical-path-method.html

[@kouroushmousavi3471]

Do you have a template for a complete single-family construction schedule that can be purchased? Thank you

[@vertex42]

I'm not a professional contractor or builder, but I used to provide a sample construction schedule as a bonus with the pro version. But, the timings were just made up ... not meant to be an actual process that follows laws or building codes.

[@michaelvanzoelen1236]

Thanks for these great videos, Everything is working fine but for some reason the Networkday function is not working. The weekends are highlighted, holidays are shown in green like in the video but when I add the named range list and I press OK the highlighted weekends are gone and holidays don't get highlighted. any clue? Thanks

[@zeenakachur]

Thank you for your videos :) I am having some issues with adding holiday_dates to: =NETWORKDAYS(J$5,J$5)=0. My weekends are shaded, but when i add the holiday_dates to the formula, like this: =NETWORKDAYS(J$5,J$5,holiday_dates)=0 then all my shaded weekends disappear. Please help :)

[@davemiles772]

check that your named range only has dates. I found an errant word along side a date. Messes things up

[@ejjourney]

My Excel is crashing if I add holidays_dates to to conditional formatting of networkdays. Please help

[@ejjourney]

I just figured it out and it worked now. I just need to select the rows with dates only before I rename it as holiday_dates. I believe Excel will have a hard time to figure that out as I highlighted the whole column with dates. Thank you again for this comprehensive tutorial for Gantt Chart

[@olivermaynard-langedijk7165]

How can I allow manual entry of the start date so that not all tasks happen in succession (i.e. task 1.1 has the same start date as task 2.1, etc.)? I want to be able to still use the workday function so that it's easy to enter workdays and auto-pop the duration, but I don't want all the other tasks to be dependent on the tasks before them...

[@vertex42]

You don't need to use a formula for the start day. You can just enter it manually, and for other tasks you can use formulas.

[@jamesmccarthy7618]

I'm using the template, any idea how to set up a repeated task in the same row?

[@vertex42]

Would require custom formulas (not just a simple answer), but gantt charts are not normally used for repeated tasks on the same row because the dependency structure doesn't work.

[@iragreen4240]

I would like to customize the Gantt to reflect weeks, not days. Can you show me how to adjust the template to reflect weeks by month, not days by week.

[@vertex42]

See the next video(s) in the series.

[@shaunmeadows3892]

Hello. Is it possible to add a ‘Show Holidays’ tick box as well? If so, how? Thanks

[@vertex42]

Probably. I haven't tried that. It would require adding some logic to the formulas.

[@maciejtomkiewicz6733]

It took me 3 hours of extra work to prepare “Holidays” sheet for next 10 years. Why? Do not forget Easter Monday and Corpus Christi which are official religious holidays in Poland (calculated on the formula: first Sunday after full Moon after Spring equinox; obviously I took the exact dates from Internet). Furthermore I had to calculate the “bridge days gaps (single workdays between holidays and weekends). E.g. “Święto Lasu” “Fiesta of Woods” the first days of May: May 1st id the Labor Day, May 3rd is Constitution Day. When it happens May 1st is on Tuesday almost everybody take a leave for Monday, Wednesday, Friday. 3 days leave give a block of 9 days holiday break 🤪. Important when calculating occupancy rate in leisure & entertainment activities (I made this initially for aquapark). I’d made this spreadsheet in 2015 and so far the actual results vary+/- 3% from forecasts.

[@vertex42]

I wonder if there is a resource somewhere that provides just a simple list of dates for holidays for various regions.

[@jennyjong2988]

is it possible to add successors and predecessors? That would make my day

[@vertex42]

The pro gantt chart does that already. If this video series is going to show that, it will probably be many episodes down the road. The critical path analysis spreadsheet also is based on defining predecessors: www.vertex42.com/ExcelTemplates/critical-path-method.html

[@hilaireoloughlin]

Anyone using Mac? I am stuck on so many issues because the interface seems different. Anyone have an idea on how to get information regarding the differences?

[@JumboKariuki]

Let's say you have a lot of phases. Say phase one to phase 30 each with about 4-5 tasks, can you create a vertical scrolling for this datasheet?

[@vertex42]

Well, the spreadsheet itself scrolls vertically, and you can use freeze panes to keep the top rows in place, so having 100s of tasks shouldn't be a problem.

[@ronaldlawas7343]

im getting an error on removing the violet bar on the very top after formatting the dates

[@chulakapitigala5147]

Hello thank you for the grant chat but this final project is very slow and can work well.

[@adamczajkowski3138]

You need do some small correction on time 07:10 - you forgot about modification in D10 (use INTL and weekend_option) on your video is also problem with start task data - from my site idea and solution is really cool - I'm waiting on part 3

[@vertex42]

D10: If E9 is already using a work day calculation (which it is), then setting the start equal to (rather than the day after) the end date does not require the use of the workday function. Granted, I'm not sure why you'd want to do it that way, but the point is that the Start column is meant to be edited, and you can use whatever formula makes sense for your use, or you could enter dates manually.

[@adamczajkowski3138]

In previous stages in D10 (and all cell below) you using formula without INTL. If for some tasks starting date is same as weekend day then gantt is incorrect - because starting from next day after (and this day after is weekend day from additional option). For full automations this start and end date calculation (without enter dates manually - manually only project start date and work days) good solution is flags or macros - future for part 3. You have right, that always you can enter start date manually for specific task - but question is - why after all these treatments in part 1 and 2

[@vertex42]

@@adamczajkowski3138 Correct, you shouldn't make a start date a weekend if you want to exclude weekends. For full automation, you may indeed want all of your tasks to be linked with formulas. However, there may be start dates or end dates that cannot be changed (due to factors out of your control), so those would be entered as dates, instead. The actual dates used in this video are completely made up and not really that important - for demonstration only. The default expected behavior of this gantt chart is that a task starts at the beginning of the day on the start date and ends at the end of the day on the end date (so if start_date = end_date, you have 1 work day). One reason you might start a task the same day as another task ends is that you realize that due to uncertainty in actual finish times or perhaps some flexibility in the schedule, you can plan to start the next task the same day as another task is finishing. Speaking of flags ... one of the awesome newer functions in Excel is the ISFORMULA() function, which you can use instead a conditional formatting rule, to highlight cells that contain formulas. That can be helpful if you have some cells that are formulas and some that are entered manually.

[@abathingape07]

If i would like to use work day on 6 day (non-workday in sunday only) how to apply "NETWORKDAYS" Function sir. @1:42

[@vertex42]

You'll need to use the NETWORKDAYS.INTL function (later in the video)

[@abathingape07]

@@vertex42 thx so much, I should to see this video to the end before, sorry.

[@12nguyenthao]

@@vertex42 sorry but could you plz to help, I cant use formula :"textjoin" :(

[@ssmediauk]

at 2:50 in I can't seem to make the solid purple bar to goo from the change of formula, when i go to edit the rule its listed as Formula: =AND(task_end>=J$5,task_start,J$5+1) when I try to edit it it throws up the error saying there is a problem with this formula. When the first character is an equal or minus sign, Excel thinks its a formula, you type: =1+1, cell shows: 2 to get around this, type an apostrophe ( ' ) first: you type '=1+1, cell shows: =1+1. Then if i put the apostrophe in all the purple bars stop working. Any ideas of master of the Excel??

[@vertex42]

You have a comma in between task_start and J$5+1. It should be a comparison.

[@edenclune7838]

@@vertex42 Hi, I am also having the same problem at 2:50. the formula is: =AND(task_start'',H$5>=$D7,H$5

[@stephenrobinson7562]

At 2:58 when you put the task_start into the AND formula, my Excel won't let me it. Queries if I'm trying to make a formula or type in the cell? Any help with this?

[@vertex42]

My guess is that you didn't define the task_start named range, yet. See the video for Part 1 to see how that named range was created.

[@stephenrobinson7562]

Hi thanks for replying. I had set up the Gantt chart from your first vid, and had set up the task_start. I double checked it when this part didn't work. I went on to complete the whole chart from this vid, this part was the only section that just didn't work. I got around it by deleting the formula in the top task end space right at the end, as apart from using it to create the formula's that were copied down it didn't seem to have any further function once the chart was fully created. Great Gantt chart by the way, any plans to do a third session? Would be good to convert into weekly and monthly dates.

[@vertex42]

@@stephenrobinson7562 Yes, I plan on eventually making a video to show adding an option for daily/weekly/monthly. Not sure yet when in the sequence that will be. The project planner on the following page uses this type of feature: www.vertex42.com/ExcelTemplates/project-planner-template.html

[@rafaabarood6060]

Please .. I need to download this file how can I ? It is one of the most beautiful files ever With Regards

[@vertex42]

See the link(s) in the description. The files for these later videos are available to those who have purchased the pro version of the gantt chart template (because these features are approaching that of the pro version).

[@yasmeenrose6958]

When I type in =IF(OR(H10="",J10=""),"-",WORKDAY(H10,J10-1,holiday_dates)) I keep getting a value error? Any advice anyone? @Vertex42

[@AcousticBenjamin]

So question. I bypassed the section where the start and end dates automatically because I need to be extremely flexible with the dates at my company. I do have the "holiday_dates" defined but if my start date is the holiday or the weekend, my work days calculation includes the day within the data bar. Did I miss something or can you not use a weekend or holiday as a start date?

[@vertex42]

Correct, you shouldn't use a weekend or holiday as a start date when using the WORKDAY.INTL and NETWORKDAYS.INTL functions.

[@AcousticBenjamin]

@@vertex42 I thought that was the case. I am not using the WORKDAY.INTL though as I do not need the functionality to change my weekends at my organization. I don't think this changes anything as you typically wouldn't use a weekend anyway. I just wanted to make sure that I didn't miss anything. The tutorial was great. I really appreciate your quick response as well!

[@mustafatan4442]

I added following formula for the start date of the first task. (=WORKDAY.INTL(project_start-1;1;weekend_option;holiday_dates)) This makes sure that start date of first task is not a weekend or holiday, even if the project start is so.

[@vertex42]

@@mustafatan4442 Excellent!

[@nurinizzati2145]

hi, i want to ask, how to fix if the weekends_option FALSE and not TRUE? Thank youu

[@vertex42]

I don't know what you mean. Sorry.

[@lucashin2858]

Great! Dear sir, where can I download the file for standing? Thanks you sir!

[@vertex42]

Not sure what you mean by "for standing", but the files are available as part of the purchase of the Pro version (see the link in the description).

[@TS-yy6jb]

I followed this step by step from video 1, was turning out great. But when I reached the holidays in column E at 5:39, the spreadsheet became a snail and started moving very slowly. Now I am afraid I wont be able to add any other functionality and have to remove an existing few. Will highly appreciate any help from anyone who can help or who faced and overcame similar issues .

[@vertex42]

Make sure that when you create your holiday_dates range that you don't use the entire column like $A:$A. Some lookup functions are smart and work fast even if you specify an entire column. However, based on my testing, NETWORKDAYS is NOT very efficient if your date range for the holidays is really long. So, when you combine that issue with the fact that conditional formatting is volatile and updates whenever the display changes, you can easily bog down Excel by specifying an entire column for the holidays argument. See my new note in the Q&A comment.

[@saurabh1782]

@@vertex42 Can you please explicitly specify what should I update instead of NETWORKDAYS(H$5,H$5,holiday_dates)=0?

[@md.jahidulislam8571]

I want to set only one day as holiday. But it always count two days. Please help.

[@vertex42]

I'm guessing you mean "weekend" instead. You'll need to use the NETWORKDAYS.INTL and WORKDAY.INTL functions and define a custom weekend string.

[@jellejanzen7224]

can some one pls help me to make this chart in week numbers and months? instead of days