You can use the WORKDAY function...
See the help file...
Hope this helps!
I need a formula that will calculate a past date. This past date must be 40 buisness days from the current business day.
Simple Example: =TODAY()-40
The Simple Example does almost what I need but I need it to count 40 business days (excluding Weekends and Holidays, if holidays can be included). The Simple example counts back 40 business days including weekends and holidays.
Thanks in advance
add the following macro code to "This Workbook:
Private Sub Workbook_Open()
AddIns("Analysis ToolPak").Installed = True
This macro automatically checks "Analysis ToolPak", which is handy if you send your files to someone else and if they don't "Analysis ToolPak" checked then they will have error messages. I think adding this small macro is very good practice to avoid instances where someone complains that file you sent has error messages.
There are currently 1 users browsing this thread. (0 members and 1 guests)