# Formula for due dates

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:38 PM GMT

## Question

QUESTION: I have several due dates I need to calculate based on a beginning date. For example, if the beginning date is 4/26/10, I need to know the date for 30 business days, 60 business days, 90 business days, and 12 months. Can I do this with excel?

ANSWER: All you need is WORKDAY function, But you need to activate first tool pack

Go to Tools - Add ins¡­ - tick Analysis Tool Pack and then Ok

Now you will have a WORKDAY available in your set of formulas

Lets say you have beginning day on A1, numbers of business days on B1, now just type in following formula

=WORKDAY(A1,B1-1)

I use "-1" in the formula assuming is beginning day include, if not, just remove it from the formula

---------- FOLLOW-UP ----------

QUESTION: Thanks so much. What if I want every day to count but want the end result to be a work day?

Once I have the end date, is it possible to put that date on a calendar such asor even in the tasks from excel?