Sum Fridays' between Two different Dates' Range.

[Faizan]

Hi,
I have Two Dates eg:
A1= 13/9/2004
A2= 27/9/2004
I want to know How many Fridays are within this range.
Help Me
thanks

 

[JulieD]

Hi Faizan

there's a formula on Chip Pearson's website for doing just this - i've
modified it for your specific request
=SUM(IF(WEEKDAY(A1-1+ROW(INDIRECT("1:"&TRUNC(A2-A1)+1)))=6,1,0))

it's an array formula so you need to enter it using control & shift & enter
and not just enter

to have a look at Chip's original formula and the theory behind it check out
http://www.cpearson.com/excel/DateTimeWS.htm
and the topic of
Number of Mondays in a Period

Hope this helps
Cheers
JuileD

 

[JulieD]

Glad to assist and thanks for the feedback.

Thanks JulieD For your Quick reply, and it really works.
thanks again.

 

[Faizan]

Thanks JulieD For your Quick reply, and it really works.
thanks again.

 

[Myrna Larson]

Install the Analysis Tool Pak, then use the NETWORKDAYS function. Help for
that function tells you how to install ATP.

 

[rp]

i have a related problem. i have two dates and i want to know only the no of
'weekdays' between the two? i've visited cpearson's website but the formula
there is very complicated. please help.

 

[Myrna Larson]

I don't know what you mean by "removing the time", and the holiday list is
optional. Look at Help for the NETWORKDAYS function if you need more
information.

 

[rp]

can you simplify by removing the time and holidays?what i just need is the
no of weekdays. pls help.