| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating a date with the CHOOSE function
Hi,
I am looking for some help calculating a date. Say I have a start date in cell A1. I need to calculate a date 30 days in the future (including weekends), however, if the last day lands on a weekend or holiday then I need the result to move to the first workday. For example: A1: Aug 18, 2006 30 days from Aug 18, 2006 is Sept 17, 2006. Because this is a Sunday, I need the result to be the next working day: Sept 18, 2006. Thank you for your help! Jen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If function calculating date | Excel Worksheet Functions | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| Mileage Claim Formula | New Users to Excel | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
| Calculating due date? | Excel Worksheet Functions | |||
Threaded Mode
