Add days, excluding weekends?

[Gil149]

Guys,
In column "A" I have dates, I want to add 2 days to that date, but not weekend dates. So if the date in A landed on a Friday and I added two days, it would be a Tuesday (adding Monday, Tuesday, skipping Saturday and Sunday). Is this possible with a single formula?

 

[T. Valko]

Guys,
In column "A" I have dates, I want to add 2 days to that date, but not weekend dates. So if the date in A landed on a Friday and I added two days, it would be a Tuesday (adding Monday, Tuesday, skipping Saturday and Sunday). Is this possible with a single formula?

Try this...

A2 = some date

=WORKDAY(A2,n)

Where n = the number of days to add.

Format as Date

Note that the WORKDAY function requires the Analysis ToolPak add-in be
installed if you're using a version of Excel prior to Excel 2007. If you
enter the formula and get a #NAME? error look in Excel help for the WORKDAY function. It'll tell you how to fix the problem.

 

[Andrew Poulsom]

You can use the WORKDAY function from the Analysis Toolpak Add-In, which must be installed. The syntax is:

=WORKDAY(start_date,days,holidays)

 

[Gil149]

Thanks guys, I was wondering if that was the right formula.