| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Working Days to a Formula
I have a spreadsheet that includes a column of dates. I want to show a
column next to this that shows what the date would be in 40 working days. I cannot use the network days formula as I only have the one date. I need to ensure that the formula allows for Bank Holidays as well as weekends. Can anyone help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding Working Days to a Formula
Use the Workday() function
-- Kind regards, Niek Otten "jpw1972" wrote in message ... I have a spreadsheet that includes a column of dates. I want to show a column next to this that shows what the date would be in 40 working days. I cannot use the network days formula as I only have the one date. I need to ensure that the formula allows for Bank Holidays as well as weekends. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =networkdays formula was working, but not in upgrade to 2003 | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Working days left in the month compared to previous months | Excel Worksheet Functions | |||
| Excel 97 - Adding Every 8th Row - Formula should work, but doesn't | Excel Worksheet Functions | |||
Linear Mode
