How to convert calendar days to business days

[JTG]

Hello,
I need a formula that will convert calendar days to workdays. I only have the start date and number of calendar days. I would then add the workdays to the start date to determine the actual end date. From there I would add one business day to provide the next start date using the same number of calendar days to determine the next end date. I don't have the info required to use either the workday or network days function. Any assistance would be appreciated.

 

[Fluff]

If you know the number of calendar days then it's just Start date + calendar days.

 

[JTG]

If you know the number of calendar days then it's just Start date + calendar days.

Thank you very much, I can't believe how simple this was. I feel like a complete fool. I didn't realize that by just adding the number of days to the start date would take into account weekends or holidays

 

[Fluff]

It won't take weekends or holidays into account, it will just give a date x calendar later.
Is that not what you wanted?

 

[JTG]

It won't take weekends or holidays into account, it will just give a date x calendar later.
Is that not what you wanted?

I need to account for weekends and holidays.

 

[Fluff]

If you had a start date of 1st May 23 & added 15 calendar days should the result be 16th May? If not what should it be?

 

[JTG]

A little additional background on what I'm trying to do. I am building out a deployment schedule and need to identify the end date for wave 1 and the start date for wave 2, the start date of wave 2 would be the next business day after wave 1 has completed. I have the deployment start date and number of calendar days, (the work can only be done on workdays, minus weekends and holidays.) The workday formula will only allow the # of workdays to be added to the start date minus the holiday schedule. The networkdays formula requires start & end date minus holidays. Since this is a multi-year project the number of workdays available over a 90 day period will change each quarter depending on the holidays that fall within the range. Hope this makes sense.

		Holidays
Start Date of wave 1​	11/1/2023​	11/23/2023
Calendar Days​	90​	11/24/2023
End Date of wave 1 needs to exclude weekends and holidays​	???​	12/25/2023
Start Date of wave 2​	???	1/1/2024
Calendar Days​	90	5/27/2024
End Date of wave 2 needs to exclude weekends and holidays​	???	7/4/2024
Start Date of wave 3….​	???	9/2/2024

 

[Fluff]

Can you please answer my question?

 

[awoohaw]

try:

Mr excel questions 35.xlsm
	A	B	C
1			Holidays
2	Start Date of wave 1	2023-11-01	2023-11-23
3	Calendar Days	90	2023-11-24
4	End Date of wave 1 needs to exclude weekends and holidays	2024-03-12	2023-12-25
5	Start Date of wave 2	2024-03-13	2024-01-01
6	Calendar Days	90	2024-05-27
7	End Date of wave 2 needs to exclude weekends and holidays	2024-07-19	2024-07-04
8	Start Date of wave 3….		2024-09-02
JTG

Cell Formulas
Range	Formula
B4,B7	B4	=WORKDAY.INTL(B2,B3,1,$C$2:$C$8)
B5	B5	=WORKDAY.INTL(B4,1,1,$C$2:$C$8)

 

[Fluff]

That does not use calendar days, but workdays. Which is why I'm trying to get clarification on what is needed as the OP originally said that adding the days to the date worked.