add number of working days to a specific date (Start Date) to have the (End Date)

[Zahirbtr]

Hi all,

I made an action plan having (#days, start date, end date) with multiple rows as actions,
I tried to use the function (WORKDAY) with start, days, and holidays to sum the days automatically,
excel 2019 considers the start of the weekend as Saturday with 2 weekend days (Sat and Sun).
I did it manually as below:

My issue is to change the weekend to be (Fri and Sat).

notes:
1. I searched for the calendar inside the options with no luck; it does not exist.
2. My Windows 10's setting for the start of the week is (Sunday).

can anyone help me, with many thanks.

 

[Zahirbtr]

PS: I used holidays as below:

 

[Zahirbtr]

holidays with format of dd/mm/yyyy

 

[Peter_SSs]

Welcome to the MrExcel board!

For the future I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with. If you have trouble with XL2BB review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of theXL2BB Instructions page linked above.

Another hint is to be more careful about getting all the information into your first post. many helpers will mainly look for threads that have no responses so when you reply several times yourself like you did here, less people will look quickly at your question.

I'm also not sure why you have the same date listed twice in your Holidays list so I have used another date in my sample below.
Your version should have this function which has the option for different weekend days. So see if this does what you want.

24 09 03.xlsm
	C	D	E	F	G
1
2	5	Tuesday,August 27, 2024	Monday,September 2, 2024		10/09/2024
3	2	Tuesday,September 3, 2024	Wednesday,September 4, 2024		5/12/2024
4	4	Thursday,September 5, 2024	Wednesday,September 11, 2024
5	10	Thursday,September 12, 2024	Wednesday,September 25, 2024
6	10	Sunday,September 29, 2024	Thursday,October 10, 2024
Add days

Cell Formulas
Range	Formula
E2:E6	E2	=WORKDAY.INTL(D2,C2-1,7,G$2:G$3)

 

[Zahirbtr]

Thanks a lot for your important notes, all were noted.

the issue was solved. appreciate your help.

 

[Peter_SSs]

You're welcome. thanks for the follow-up.