days calculation

's Computer Specifications

Hi All
The following formula is calculating the no of days without holidays, so I
want this formula in excel function way.
=SUMPRODUCT(INT((D5-C5+WEEKDAY(C5-{1,2,3,4,5}))/7))

's Computer Specifications

I mean that I want this formula in UDF form

"Yousoft" wrote:

> Hi All
> The following formula is calculating the no of days without holidays, so I
> want this formula in excel function way.
> =SUMPRODUCT(INT((D5-C5+WEEKDAY(C5-{1,2,3,4,5}))/7))
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Days Calculation	Firoz Khan	Microsoft Excel Misc	11	10th Aug 2009 12:29 PM
days calculation	afdmello	Microsoft Excel Discussion	5	9th Jul 2009 01:33 AM
days calculation	ssylee	Microsoft Excel Misc	2	11th Jan 2009 06:20 AM
How to calculation no. of days (only working days) between two dat	=?Utf-8?B?Vml2aWFuIENoYW4=?=	Microsoft Excel Misc	1	26th Jul 2007 09:16 AM
Please Help With Days Elapsed And Days Remaining Calculation	Scoooter	Microsoft Excel Worksheet Functions	2	14th Jun 2006 05:10 PM