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.

 

[awoohaw]

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.

I took:

I need to account for weekends and holidays.

as meaning that weekends and holidays are to be excluded, otherwise your original formula would have been accurate.
and i think OP was using networkdays instead of workdays.intl function.

 

[Fluff]

You only need to use the INTL version of those functions if you want something other than Sat/Sun as weekends.