change weekend days in Excel

Posted on 2014-02-02
Medium Priority
Last Modified: 2014-02-05

In my country weekends are Friday and Saturday instead of Sat and Sun. So, how can change it in Excel due to I have some functions to calculate working days ??

Question by:obad62
LVL 18

Assisted Solution

by:Steven Harris
Steven Harris earned 668 total points
ID: 39828068
Are you using networkwordays() by chance?  Switch to:

=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])

In your case, [weekend] = 7, so - If start date is A1, end date is B2:

LVL 81

Accepted Solution

byundt earned 668 total points
ID: 39828721
There is also WORKDAY.INTL, which is equivalent to WORKDAY but lets you specify the days of the weekend. Like NETWORKDAYS.INTL as mentioned by ThinkSpaceSolutions, your Friday & Saturday weekend would be specified by [weekend] = 7

To get a date 12 working days in the future, you would use:
where HolidayList is a named range listing public holidays in your country

NETWORKDAYS.INTL and WORKDAY.INTL require Excel 2010 or later.
LVL 50

Assisted Solution

by:barry houdini
barry houdini earned 664 total points
ID: 39829407
In earlier versions of Excel you can modify the regular NETWORKDAYS function to treat Friday and Saturday as weekend days by "offsetting" the dates, e.g. like this:


[+2 would give you Thurs/Fri weekend, +3 Wed/Thurs etc.]

With holidays in H2:H10 you can also exclude holidays with this version


For WORKDAY try this


where A2 is start date and C2 the number of days to add

Again you can exclude holidays with this version


regards, barry

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question