Prev: how do you calculate mortgage interest in 2007 Excel ?
Next: Read only prompt?
From: Shukla456 on 23 Mar 2010 05:24
Can any body tell me how to calculate the number of Fridays between two dates
( say 1 Jan 10 to 15 June 10)?

Is there is a way to do this in excel ?

Thanks in advance..

Best Regards,
From: Bob Phillips on 23 Mar 2010 05:30
Try

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(--"2010-01-01"&":"&--"2010-06-15")))=6))

--

HTH

Bob

"Shukla456" <Shukla456(a)discussions.microsoft.com> wrote in message
news:4898339F-C30A-43CA-8B91-EBA60F2F8D7F(a)microsoft.com...
> Can any body tell me how to calculate the number of Fridays between two
> dates
> ( say 1 Jan 10 to 15 June 10)?
>
> Is there is a way to do this in excel ?
>
> Thanks in advance..
>
> Best Regards,


From: Mike H on 23 Mar 2010 05:44
Hi,

Like this. The 6 equals Friday, other days of the week are in the table.

=INT((WEEKDAY(A1-6)-A1+A2)/7)

1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Shukla456" wrote:

> Can any body tell me how to calculate the number of Fridays between two dates
> ( say 1 Jan 10 to 15 June 10)?
>
> Is there is a way to do this in excel ?
>
> Thanks in advance..
>
> Best Regards,
From: Gary''s Student on 23 Mar 2010 05:45
With dates in A1 and A2:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)),2)=5))
--
Gary''s Student - gsnu201001


"Shukla456" wrote:

> Can any body tell me how to calculate the number of Fridays between two dates
> ( say 1 Jan 10 to 15 June 10)?
>
> Is there is a way to do this in excel ?
>
> Thanks in advance..
>
> Best Regards,
From: JLatham on 23 Mar 2010 15:13
You may have noticed that Mike and Bob tested against a value of 6, while
Gary''s Student tested against a value of 5. It's same thing, but Gary
forced the WEEKDAY() function to cause Monday to = 1, instead of Monday = 2
as Mike and Bob setup for. See Excel's Help topic for WEEKDAY for more
information about this.


"Shukla456" wrote:

> Can any body tell me how to calculate the number of Fridays between two dates
> ( say 1 Jan 10 to 15 June 10)?
>
> Is there is a way to do this in excel ?
>
> Thanks in advance..
>
> Best Regards,
 |  Next  |  Last
Pages: 1 2
Prev: how do you calculate mortgage interest in 2007 Excel ?
Next: Read only prompt?