Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date formula needed
I need a formula to calculate the date 30 business days from a given date.
Any help appreciated. |
#2
|
|||
|
|||
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. "VDan" wrote: I need a formula to calculate the date 30 business days from a given date. Any help appreciated. |
#3
|
|||
|
|||
hi,
assuming your given date is in cell A1, try this..... =WORKDAY(A1,30) if you want to use diffenent numbers of days, put the number of days in cell B1 =WORKDAY(A1,B1) IF you want to go backwards into the past, enter negative days adjust the formula to fit your data. Regards FSt1 "VDan" wrote: I need a formula to calculate the date 30 business days from a given date. Any help appreciated. |
#4
|
|||
|
|||
Just tried it. Thank you, it works!
"Duke Carey" wrote: 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. "VDan" wrote: I need a formula to calculate the date 30 business days from a given date. Any help appreciated. |
#5
|
|||
|
|||
VDan Wrote: 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 -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=400782 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Date formula needed | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
formula IF returning current date | Excel Worksheet Functions | |||
Date formula | Excel Discussion (Misc queries) |