Adding a specified number of business days to a start date

L

LLSherry

hell

I am hoping someone can help me put a function into my worksheet when using dates
I have two columns one is start date and I need to calculate an end date in the second column that is plus 4 business days. Can anyone tell me if there is a formula for this? I have checked my excel bible and found the networkdays function but this seems to give the number of business days between a specified start date and a specified stop date. As well, how can I have it determine what days are stat holidays and not business days. Do I need to somehow have it looking at my calendar

Any assistance would be very much appreciated

Thanks all!!!!!!!!
 
F

Frank Kabel

Hi
try
=WORKDAY(A1,4)
where A1 stores your start date
you may also add a third parameter to WORKDAY referencing a list of
holidays (see Excel help for more details)

Frank
 
F

Frank Kabel

Hi
you probably have to install the Analysis Toolpak Add-In. Goto 'Tools -
Add-ins.' and check this Add-in
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Office365 Family + TXT or MX Domain 0
Display weeks from a Milestone 0
How to implement two shifts per day with multiple teams 0
How to Time time Diff for Completion of Activity (Exc Holiday List & Non Bus Hours) 2
End Date/Time adding business hours 1
returning a date 7 business day excluding holidays in the future 2
Calculate the median value before a specified list 0
Calculate days help 2

Top