| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
business days - trade date plus 3
is there a calendar function in excel that will allow me to add 3 days to a *yyyymmdd * formatted date and skip weekends... Basically want to derive a settlement date, which is always trade date +3.. i am given the trade date... we only count buisness days... weekends are not include - i dont care about holidays (can fix those manually) thanks!!!! -- clegge ------------------------------------------------------------------------ clegge's Profile: http://www.excelforum.com/member.php...o&userid=29927 View this thread: http://www.excelforum.com/showthread...hreadid=500218 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Formula Needed-Business Days | Excel Discussion (Misc queries) | |||
| Need date to appear 90 days later than initial date entered | Excel Worksheet Functions | |||
| convert date of birth to mos. old now, 30 and 60 days | Excel Worksheet Functions | |||
| Macro Quandry | Excel Discussion (Misc queries) | |||
| business days between 2 date feilds | Excel Worksheet Functions | |||
Threaded Mode
