Download the workbook here:

Excel’s workday function is great when you need to calculate an end date based on a given number of working days – which means you need to exclude weekends and holidays. Some examples are

– creating a project timeline

– creating a reporting timetable

In this video I show you both examples.

Excel’s workday function assumes weekends fall on Saturdays and Sundays. In case the weekends in your country fall on other days, you will need to use Workday.intl where you have an additional option to select the weekend days.

★ My Online Excel Courses ►

✉ Subscribe & get my TOP 10 Excel formulas e-book for free

EXCEL RESOURCES I Recommend:

Get Office 365:

Microsoft Surface:

GEAR

Camera:

Screen recorder:

Microphone:

Lights:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel

Nguồn: https://sylvaniachristian.com/

Xem thêm bài viết: https://sylvaniachristian.com/category/cong-nghe

When I followed the procedure, the end date became " #value!". How to fix this?

There are so many comments and queries @leila but you reply hardly to any.

In our office it's odd and even saturdays. All odd saturdays are working and even saturdays are holidays of course all Sundays are off. So how should we do that in planning?

Thank for this video

Thank you ,and I would like to ask you about the holiday and weekends column , did you type in the dates by yourself or there are any easier method ?

Whenever I miss the perfect of something ,I go to leila to catch the perfect , thanks to the lady of perfect .

How to get any Sunday date. ex.get date of 4th Sunday of September 2019

❤️❤️❤️❤️❤️👌👏

How to get working days only by using Networkday.intl, with out start day & end day

This function continuously returns #VALUE, in spite of the fact that my starting date function is formatted as a date value and my # of Work Days is formatted as a number?

Teaching methods are very useful

Hi Leila, many thanks for the video, it got me a long way along the tortuous route I have to take get my forecasting correct. One thing: in construction, the start date is usually counted as a work day which Excel miscalculates unless the first calculated date is based upon Start Date-1.

Hello .. I'm following all your videos from last week. Your videos are very useful..

I have once quick question for you , Please help me out because I'm stuck here.

Question : For ex : I have a one date as a reference and from this reference date i need to get 3 different dates i.e ( 7 days before the ref date, 2 days before the ref date & 1 day before the ref date) but the twist is that the new date should fall on Weekday and not on Weekend( i.e Sat & sun) & Holidays.

Please help me out , i'm trying to figure out this from many days.

WOW ! Thank you

How can I find the end date if I assign different hours to the week days, so not every day would have the same work hours, and how can I fully customise the weekdays if I need more than 2? I have been struggle with this for a while now

great, but how about if I have diferent dates with different amount of hours? let say from Monday to Thursday the default time is 6 hours but on Fridays are 3 hours and saturdays and sundays are free days, but at some point I need an specific date to work more than 6 hours and/or that I need a particular saturday to work, so how can I calculate based on that variables?

I aam tring to make a cronogram based on each participant, so their disponibility could be very diferent from each other, tring to do it throug a table where they can fill the data through weeks after telling if they are going to fill the time with hours, mins, etc, and if it is per unit or per ampunt of units asigned, I will leave a link where yo could find my very rough excel file: https://1drv.ms/f/s!AtYtwUtCJl08g_4544Qj4lC7QFz0Jg

hi LEILA, how do i do this if i need to include weekends and holidays.

I have set of data wherein I have start end and end date but there manay cells therein has no end date given (there are blank as task has not completed) in this case which formula I should use and also I have to exlcude weekend.. Pls suggest.

Great tutorial; however I don't want it to calculate so that it takes out all the weekends. I just want the end date not to be a weekend. If anyone can help with that it would be appreciated.

If we have any task which will complete in half days can you tell how it will work

Thank you that's really helpful!

Awesome

Thanks! Is there a way to round the end date to the nearest, say, Thursday? But if it already lands on a Thursday, it should stay on that Thursday rather than rounding up or down.

"This is a weekend and a holiday. It's very unfortunate" 🙂