I need to count the number of Fridays in a range of dates, e.g. how many
Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
very grateful for your help.
I need to count the number of Fridays in a range of dates, e.g. how many
Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
very grateful for your help.
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)))=6))
where cell a1 holds the date 6/14/05 and b1 holds 6/29/05
"L_n_da" <[email protected]> wrote in message
news:[email protected]...
>I need to count the number of Fridays in a range of dates, e.g. how many
> Fridays between 14 June 05 and 29 June 05 (including these two days). I'd
> be
> very grateful for your help.
On Wed, 25 May 2005 12:43:25 -0700, L_n_da <[email protected]>
wrote:
>I need to count the number of Fridays in a range of dates, e.g. how many
>Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
>very grateful for your help.
A1: Start Date
A2: End Date
=INT((A2-WEEKDAY(A2-5)-A1+8)/7)
In general:
=INT((A2-WEEKDAY(A2+1-DOW)-A1+8)/7)
where DOW is replaced by the Day of the Week where Sunday=1 and Saturday=7.
--ron
In article <[email protected]>,
[email protected] says...
> I need to count the number of Fridays in a range of dates, e.g. how many
> Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
> very grateful for your help.
>
=INT((Finish-Start)/7)+IF(OR(WEEKDAY(Start-6)>WEEKDAY(Finish-6),WEEKDAY
(Finish)=6),1,0)
seems to work!
In article <[email protected]>,
[email protected] says...
> I need to count the number of Fridays in a range of dates, e.g. how many
> Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
> very grateful for your help.
>
=INT((Finish-Start)/7)+IF(OR(WEEKDAY(Start-6)>WEEKDAY(Finish-6),WEEKDAY
(Finish)=6),1,0)
seems to work!
In article <[email protected]>,
[email protected] says...
> I need to count the number of Fridays in a range of dates, e.g. how many
> Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
> very grateful for your help.
>
=INT((Finish-Start)/7)+IF(OR(WEEKDAY(Start-6)>WEEKDAY(Finish-6),WEEKDAY
(Finish)=6),1,0)
seems to work!
In article <[email protected]>,
[email protected] says...
> I need to count the number of Fridays in a range of dates, e.g. how many
> Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
> very grateful for your help.
>
=INT((Finish-Start)/7)+IF(OR(WEEKDAY(Start-6)>WEEKDAY(Finish-6),WEEKDAY
(Finish)=6),1,0)
seems to work!
In article <[email protected]>,
[email protected] says...
> I need to count the number of Fridays in a range of dates, e.g. how many
> Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
> very grateful for your help.
>
=INT((Finish-Start)/7)+IF(OR(WEEKDAY(Start-6)>WEEKDAY(Finish-6),WEEKDAY
(Finish)=6),1,0)
seems to work!
In article <[email protected]>,
[email protected] says...
> I need to count the number of Fridays in a range of dates, e.g. how many
> Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
> very grateful for your help.
>
=INT((Finish-Start)/7)+IF(OR(WEEKDAY(Start-6)>WEEKDAY(Finish-6),WEEKDAY
(Finish)=6),1,0)
seems to work!
In article <[email protected]>,
[email protected] says...
> I need to count the number of Fridays in a range of dates, e.g. how many
> Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
> very grateful for your help.
>
=INT((Finish-Start)/7)+IF(OR(WEEKDAY(Start-6)>WEEKDAY(Finish-6),WEEKDAY
(Finish)=6),1,0)
seems to work!
In article <[email protected]>,
[email protected] says...
> I need to count the number of Fridays in a range of dates, e.g. how many
> Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
> very grateful for your help.
>
=INT((Finish-Start)/7)+IF(OR(WEEKDAY(Start-6)>WEEKDAY(Finish-6),WEEKDAY
(Finish)=6),1,0)
seems to work!
In article <[email protected]>,
[email protected] says...
> I need to count the number of Fridays in a range of dates, e.g. how many
> Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
> very grateful for your help.
>
=INT((Finish-Start)/7)+IF(OR(WEEKDAY(Start-6)>WEEKDAY(Finish-6),WEEKDAY
(Finish)=6),1,0)
seems to work!
In article <[email protected]>,
[email protected] says...
> I need to count the number of Fridays in a range of dates, e.g. how many
> Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
> very grateful for your help.
>
=INT((Finish-Start)/7)+IF(OR(WEEKDAY(Start-6)>WEEKDAY(Finish-6),WEEKDAY
(Finish)=6),1,0)
seems to work!
In article <[email protected]>,
[email protected] says...
> I need to count the number of Fridays in a range of dates, e.g. how many
> Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
> very grateful for your help.
>
=INT((Finish-Start)/7)+IF(OR(WEEKDAY(Start-6)>WEEKDAY(Finish-6),WEEKDAY
(Finish)=6),1,0)
seems to work!
In article <[email protected]>,
[email protected] says...
> I need to count the number of Fridays in a range of dates, e.g. how many
> Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
> very grateful for your help.
>
=INT((Finish-Start)/7)+IF(OR(WEEKDAY(Start-6)>WEEKDAY(Finish-6),WEEKDAY
(Finish)=6),1,0)
seems to work!
In article <[email protected]>,
[email protected] says...
> I need to count the number of Fridays in a range of dates, e.g. how many
> Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
> very grateful for your help.
>
=INT((Finish-Start)/7)+IF(OR(WEEKDAY(Start-6)>WEEKDAY(Finish-6),WEEKDAY
(Finish)=6),1,0)
seems to work!
In article <[email protected]>,
[email protected] says...
> I need to count the number of Fridays in a range of dates, e.g. how many
> Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
> very grateful for your help.
>
=INT((Finish-Start)/7)+IF(OR(WEEKDAY(Start-6)>WEEKDAY(Finish-6),WEEKDAY
(Finish)=6),1,0)
seems to work!
In article <[email protected]>,
[email protected] says...
> I need to count the number of Fridays in a range of dates, e.g. how many
> Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
> very grateful for your help.
>
=INT((Finish-Start)/7)+IF(OR(WEEKDAY(Start-6)>WEEKDAY(Finish-6),WEEKDAY
(Finish)=6),1,0)
seems to work!
In article <[email protected]>,
[email protected] says...
> I need to count the number of Fridays in a range of dates, e.g. how many
> Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
> very grateful for your help.
>
=INT((Finish-Start)/7)+IF(OR(WEEKDAY(Start-6)>WEEKDAY(Finish-6),WEEKDAY
(Finish)=6),1,0)
seems to work!
In article <[email protected]>,
[email protected] says...
> I need to count the number of Fridays in a range of dates, e.g. how many
> Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
> very grateful for your help.
>
=INT((Finish-Start)/7)+IF(OR(WEEKDAY(Start-6)>WEEKDAY(Finish-6),WEEKDAY
(Finish)=6),1,0)
seems to work!
In article <[email protected]>,
[email protected] says...
> I need to count the number of Fridays in a range of dates, e.g. how many
> Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
> very grateful for your help.
>
=INT((Finish-Start)/7)+IF(OR(WEEKDAY(Start-6)>WEEKDAY(Finish-6),WEEKDAY
(Finish)=6),1,0)
seems to work!
In article <[email protected]>,
[email protected] says...
> I need to count the number of Fridays in a range of dates, e.g. how many
> Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
> very grateful for your help.
>
=INT((Finish-Start)/7)+IF(OR(WEEKDAY(Start-6)>WEEKDAY(Finish-6),WEEKDAY
(Finish)=6),1,0)
seems to work!
In article <[email protected]>,
[email protected] says...
> I need to count the number of Fridays in a range of dates, e.g. how many
> Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
> very grateful for your help.
>
=INT((Finish-Start)/7)+IF(OR(WEEKDAY(Start-6)>WEEKDAY(Finish-6),WEEKDAY
(Finish)=6),1,0)
seems to work!
In article <[email protected]>,
[email protected] says...
> I need to count the number of Fridays in a range of dates, e.g. how many
> Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
> very grateful for your help.
>
=INT((Finish-Start)/7)+IF(OR(WEEKDAY(Start-6)>WEEKDAY(Finish-6),WEEKDAY
(Finish)=6),1,0)
seems to work!
In article <[email protected]>,
[email protected] says...
> I need to count the number of Fridays in a range of dates, e.g. how many
> Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
> very grateful for your help.
>
=INT((Finish-Start)/7)+IF(OR(WEEKDAY(Start-6)>WEEKDAY(Finish-6),WEEKDAY
(Finish)=6),1,0)
seems to work!
In article <[email protected]>,
[email protected] says...
> I need to count the number of Fridays in a range of dates, e.g. how many
> Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
> very grateful for your help.
>
=INT((Finish-Start)/7)+IF(OR(WEEKDAY(Start-6)>WEEKDAY(Finish-6),WEEKDAY
(Finish)=6),1,0)
seems to work!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks