Posted to microsoft.public.excel.misc

external usenet poster

Posts: 31

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I calculation vacation accrual?	WizTech	Excel Worksheet Functions	2	April 4th 23 10:51 AM
pro-rated formula	Dani14850	Excel Worksheet Functions	1	January 23rd 07 02:52 PM
Vacation Pay Calculation	Jaleel	Excel Discussion (Misc queries)	5	August 20th 06 02:47 PM
Vacation Time calculation... HELP!	brubru	Excel Discussion (Misc queries)	1	July 22nd 06 10:10 PM
Vacation	jopla	Excel Worksheet Functions	1	December 10th 04 08:07 PM

All times are GMT +1. The time now is 02:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us