First add business days to a date (excluding weekends and holidays), then add regular days

[schien]

Need a formula that'll allow me to add days to a date and exclude weekends as well as federal holidays in the process.


Example:
If my date is March 25th, 2014 and I need to add 5 business days to it. The result I'm looking for is April 2, 2014 (not adding the weekends, March 29 and 30; also excluding March 31, a Federal Holiday).


Want to just add "business" or "working day" to the date.


In addition, would like to add days to the result above.


Example:
Would like to add 5 days to result of April 2, 2014 from above to get to the final result of April 7, 2014.


Thanks very much in advance!

 

[Slizer6893]

So something like ?

=Workday("date",5)

I missed the holiday part, if you have an array with dates that are holidays include it after the 5. Or just type in the serial number for the date.


Missed the third part..too wow I am ignoring reading today. You can reference any day and just do an addition problem

=("date")+5 (This will add 5 calendar days)

 

[BlueHornet]

Welcome to the board.

A somewhat easier way to approach this is to have a dedicated sheet set up to list holidays in one column (with or without a corresponding name or other reference in an adjoining column for ease of use). So if you have your holidays listed in A:A on a sheet named "Holidays", then:

=workday( "4/2/14", 5, Holidays!A:A)

This way you don't have to do the mental gymnastics to recall holidays in advance, as long as the sheet that lists them is kept up to date, which is a simpler maintenance process.

 

[Aladin Akyurek]

A bit fancier...

=WORKDAY(A2,5,{"3/31/2014"})+5

where A2 is 3/25/2014. Adjust the format of the date string between the curly brackets.