Posted to microsoft.public.excel.misc

[email protected] tia.abdelkarim@gmail.com is offline

external usenet poster

Posts: 5

Annual leave without holidays

Hi

I am working as an H.r and i am looking for a formula concerning the
annual leave

I have already found a formula that gives the total of the days
allowed without the weekends

But i do need to calculate the days taken excluding the weekends and
the holidays

A: starting date
B: Total of Days allowed
C: New Year 31/12/2008
D: Ester 24/3/2008
Etc

Please advise

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
Annual leave	[email protected]	Excel Discussion (Misc queries)	3	March 12th 08 02:20 PM
Dates, Holidays and maternity leave...	Ashley	Excel Discussion (Misc queries)	0	January 16th 08 04:51 AM
Annual Leave Planner	peter	Excel Discussion (Misc queries)	1	November 1st 06 10:17 AM
Annual Leave	Aussie Peter	Excel Discussion (Misc queries)	1	January 31st 06 03:25 AM
Tracking annual leave	opos	New Users to Excel	4	August 15th 05 11:09 AM

All times are GMT +1. The time now is 12:48 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us