Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pro-rated Vacation Calculation
Hello -
I am trying to find the formula (or formulas) that will allow me to enter in two dates and find the number of pro-rated vacation days one has, based on 20 per year. For example: Start End Date Pro-rated Vacation 2/22/2008 12/31/2008 ???? Any help? D. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pro-rated Vacation Calculation
Start date in A1, End date in B1, 1-1-2008 in A2:
=NETWORKDAYS(A1,B1)/NETWORKDAYS(A2,B1)*20 If you get a #NAME error: ToolsAdd-ins, check Analysis Toolpak -- Kind regards, Niek Otten Microsoft MVP - Excel "Danielle" wrote in message ... | Hello - | | I am trying to find the formula (or formulas) that will allow me to enter in | two dates and find the number of pro-rated vacation days one has, based on 20 | per year. | | For example: | | Start End Date Pro-rated Vacation | 2/22/2008 12/31/2008 ???? | | | Any help? | | D. | |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pro-rated Vacation Calculation
THANK YOU SO MUCH... THIS WORKS PERFECTLY. :-)
"Niek Otten" wrote: Start date in A1, End date in B1, 1-1-2008 in A2: =NETWORKDAYS(A1,B1)/NETWORKDAYS(A2,B1)*20 If you get a #NAME error: ToolsAdd-ins, check Analysis Toolpak -- Kind regards, Niek Otten Microsoft MVP - Excel "Danielle" wrote in message ... | Hello - | | I am trying to find the formula (or formulas) that will allow me to enter in | two dates and find the number of pro-rated vacation days one has, based on 20 | per year. | | For example: | | Start End Date Pro-rated Vacation | 2/22/2008 12/31/2008 ???? | | | Any help? | | D. | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculation vacation accrual? | Excel Worksheet Functions | |||
pro-rated formula | Excel Worksheet Functions | |||
Vacation Pay Calculation | Excel Discussion (Misc queries) | |||
Vacation Time calculation... HELP! | Excel Discussion (Misc queries) | |||
Vacation | Excel Worksheet Functions |