Adding Business Days in Excel

Because i can never remember the cool stuff i learn in excel, i tend to just put it in as a blog post so i can find it later, and hopefully help osmeone else if they need the same thing in the future!

Latest Excel questions was – how do i add 7 business days to a date in excel…

According to plain old math and using my fingers and a calendar…

 

Start End Total Days
1/28/2013 2/6/2013 9
1/29/2013 2/7/2013 9
1/30/2013 2/8/2013 9
1/31/2013 2/11/2013 11
2/1/2013 2/12/2013 11

I started with a monday, and adding 7 business days for monday thru wednesday gives you 9 total days, for thursday and friday you end up with 11 total days.

The workday function in excel allows the you to enter the start date, the number of days to add, and if you happen to have holidays there is a list parameter to add them in there!

I used the function as follows:

=WORKDAY(A1,7)

A1 contains by date and i know i only need to know 7 business days for my current case!

Where i found my info was here