Solved How to Calculate next 20 or 40 Business days.

January 14, 2015 at 10:12:11
Specs: Windows 7
Hi ..
It is like if I enter today's date in the specified row and next row next 10 working days than I should able to get the exact date (after excluding these holidays i.e sat & sun and also if any national holidays which I will give it).
How does it work what is the Macro used please help me.

Very much thanks in advance.

See More: How to Calculate next 20 or 40 Business days.

Report •

January 14, 2015 at 10:22:16
✔ Best Answer
You shouldn't need a macro. Take a look at the WORKDAY function where you specify a start date, the number of workdays and a list of user defined "holidays" to exclude. Saturdays and Sundays are automatically excluded.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03

Report •
Related Solutions

Ask Question