| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
BUSINESS DAYS - Need function that will list next 3 business days.
This seems simple but I can't seem to figure out how to do it.
In a worksheet I have a cell into which today's date is entered automatically. Using =Now() I want excel to give me the next three business days (i.e. next 3 days excluding holidays and weekends) For example if today is Thursday 2/15, I want it to give me Friday 2/16 Monday 2/19 Tuesday 2/20. Any bright ideas? Monday 2/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Diff in business days | Excel Discussion (Misc queries) | |||
| Calculating 10 Business Days from the Last Business Day of the Mon | Excel Worksheet Functions | |||
| Business Days Only | Excel Discussion (Misc queries) | |||
| How to calculate # days between business days | Excel Programming | |||
| Normal Days to business days | Excel Programming | |||
Threaded Mode
