• Status: Solved
• Priority: Medium
• Security: Public
• Views: 4303

# change weekend days in Excel

Hi

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 ??

Thanks
0
3 Solutions

PresidentCommented:
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:

=NETWORKDAYS.INTL(A1,B1,7)
0

Commented:
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:
=WORKDAY.INTL(TODAY(),12,7,HolidayList)
where HolidayList is a named range listing public holidays in your country

NETWORKDAYS.INTL and WORKDAY.INTL require Excel 2010 or later.
1

Commented:
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:

=NETWORKDAYS(A2+1,B2+1)

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

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

=NETWORKDAYS(A2+1,B2+1,INDEX(H\$2:H\$10+1,0))

For WORKDAY try this

=WORKDAY(A2+1,C2)-1

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

Again you can exclude holidays with this version

=WORKDAY(A2+1,C2,INDEX(H\$2:H\$10+1,0))-1

regards, barry
1
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.