| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Date Calculation
Hi
Anyone know how I can calculate the amount of days between two dates not taking into account weekends and possible Bank holidays? TIA Steve |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Date Calculation
Hi Steve,
Look in HELP for the NETWORKDAYS() function -- Kind regards, Niek Otten Microsoft MVP - Excel "Steve" wrote in message ups.com... | Hi | | Anyone know how I can calculate the amount of days between two dates | not | taking into account weekends and possible Bank holidays? | | TIA | Steve | |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Date Calculation
I've tried the =networkdays(A1,A2) function, formatted the cell as a number
but it keeps coming up with #NAME? TIA Steve "Niek Otten" wrote in message ... Hi Steve, Look in HELP for the NETWORKDAYS() function -- Kind regards, Niek Otten Microsoft MVP - Excel "Steve" wrote in message ups.com... | Hi | | Anyone know how I can calculate the amount of days between two dates | not | taking into account weekends and possible Bank holidays? | | TIA | Steve | |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Date Calculation
I've tried the =networkdays(A1,A2) function, formatted the cell as a number but it keeps coming up with #NAME? I also forgot to add I installed the Analysis Toolpak TIA Steve "Niek Otten" wrote in message ... Hi Steve, Look in HELP for the NETWORKDAYS() function -- Kind regards, Niek Otten Microsoft MVP - Excel "Steve" wrote in message ups.com... | Hi | | Anyone know how I can calculate the amount of days between two dates | not | taking into account weekends and possible Bank holidays? | | TIA | Steve | |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Date Calculation
<I also forgot to add I installed the Analysis Toolpak
What do you mean by "installed"? Did you ToolsAdd-ins, check Analysis Toolpak? -- Kind regards, Niek Otten Microsoft MVP - Excel "Steve" <swr1953(at)yahoo(dot)co(dot)uk wrote in message ... | | I've tried the =networkdays(A1,A2) function, formatted the cell as a number | but it keeps coming up with #NAME? | | I also forgot to add I installed the Analysis Toolpak | | TIA | Steve | | | | "Niek Otten" wrote in message | ... | Hi Steve, | | Look in HELP for the NETWORKDAYS() function | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | | "Steve" wrote in message | ups.com... | | Hi | | | | Anyone know how I can calculate the amount of days between two dates | | not | | taking into account weekends and possible Bank holidays? | | | | TIA | | Steve | | | | | | | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to return a value between date ranges | Excel Worksheet Functions | |||
| Date Calculation to exclude weekends | Excel Worksheet Functions | |||
| Calculation based with Range of Date | New Users to Excel | |||
| search for latest date | Excel Worksheet Functions | |||
| Due Date Calculation? | New Users to Excel | |||
Linear Mode
