V
VDan
I need a formula to calculate the date 30 business days from a given date.
Any help appreciated.
Any help appreciated.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Duke Carey
Make sure you have the Analysis Toolpak installed (Tools->Addins & make sure
the Analysis Toolpak is checked).
Once installed you can use the WORKDAY() function that will do just what you
want
From the Help file
WORKDAY()
Returns a number that represents a date that is the indicated number of
working days before or after a date (the starting date). Working days exclude
weekends and any dates identified as holidays. Use WORKDAY to exclude
weekends or holidays when you calculate invoice due dates, expected delivery
times, or the number of days of work performed.
If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.
the Analysis Toolpak is checked).
Once installed you can use the WORKDAY() function that will do just what you
want
From the Help file
WORKDAY()
Returns a number that represents a date that is the indicated number of
working days before or after a date (the starting date). Working days exclude
weekends and any dates identified as holidays. Use WORKDAY to exclude
weekends or holidays when you calculate invoice due dates, expected delivery
times, or the number of days of work performed.
If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.
V
VDan
Just tried it. Thank you, it works!
Duke Carey said:Make sure you have the Analysis Toolpak installed (Tools->Addins & make sure
the Analysis Toolpak is checked).
Once installed you can use the WORKDAY() function that will do just what you
want
From the Help file
WORKDAY()
Returns a number that represents a date that is the indicated number of
working days before or after a date (the starting date). Working days exclude
weekends and any dates identified as holidays. Use WORKDAY to exclude
weekends or holidays when you calculate invoice due dates, expected delivery
times, or the number of days of work performed.
If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.
P
Paul Sheppard
VDan said:I need a formula to calculate the date 30 business days from a given
date.
Any help appreciated.
Hi VDan
Try the Workday Function
If your date is in cell A1 you can enter in B! the following
=WORKDAY(A1,30)
This can also be adjusted for Holidays