Number of Specific Day within Dates

[Abdul]

Hi,

Is there a way to find how many Day (eg. wednesdays) within a a date
range?

Like how many Wednesdays (any given Day) falling between June 1, 2009
Till June 21, 2009

Thanks,

 

[Teethless mama]

=End date - Start date

 

[Shane Devenshire]

Hi,

You really need to give us more info. If you are trying to count the number
of days between two dates in cell A1 and A2 then
=A2-A1
If you are trying to count the number of days between A1 and today, then
=TODAY()-A1
If....

 

[zxcv]

Hi,

Is there a way to find how many Day (eg. wednesdays) within a a date
range?

Like how many Wednesdays (any given Day) falling between June 1, 2009
Till June 21, 2009

Thanks,

Let's say that you have a sheet set up like this, A2 shows your start
date, B2 shows your end date, and C2 though I2 will have the count of
Sundays through Saturdays, try this formula in C2 through I2:

=FLOOR(($B2-$A2+1)/7,1)+IF(($B2-$A2+1)/7>FLOOR(($B2-$A2+1)/7,1),IF
(WEEKDAY($B2)>=WEEKDAY($A2),IF(AND(WEEKDAY($B2)>=COLUMN()-2,COLUMN
()-2>=WEEKDAY($A2)),1,0),IF(OR(AND(COLUMN()-2<=WEEKDAY($A2),COLUMN
()-2<=WEEKDAY($B2)),AND(COLUMN()-2>=WEEKDAY($A2),COLUMN()-2>=WEEKDAY
($B2))),1,0)),0)

 

[Ron Rosenfeld]

Let's say that you have a sheet set up like this, A2 shows your start
date, B2 shows your end date, and C2 though I2 will have the count of
Sundays through Saturdays, try this formula in C2 through I2:

=FLOOR(($B2-$A2+1)/7,1)+IF(($B2-$A2+1)/7>FLOOR(($B2-$A2+1)/7,1),IF
(WEEKDAY($B2)>=WEEKDAY($A2),IF(AND(WEEKDAY($B2)>=COLUMN()-2,COLUMN
()-2>=WEEKDAY($A2)),1,0),IF(OR(AND(COLUMN()-2<=WEEKDAY($A2),COLUMN
()-2<=WEEKDAY($B2)),AND(COLUMN()-2>=WEEKDAY($A2),COLUMN()-2>=WEEKDAY
($B2))),1,0)),0)

Tagging on here because I don't see the original post. But a simpler formula:

The number of DOW (1= Sunday, 2 = Monday, ..., 7 = Saturday) between a start
date (A1) and an end date (A2) is :

=INT((A2-WEEKDAY(A2+1-DOW)-A1+8)/7)
--ron

 

[zxcv]

Tagging on here because I don't see the original post.  But a simpler formula:

The number of DOW (1= Sunday, 2 = Monday, ..., 7 = Saturday) between a start
date (A1) and an end date (A2) is :

=INT((A2-WEEKDAY(A2+1-DOW)-A1+8)/7)
--ron- Hide quoted text -

- Show quoted text -

Thanks. That was much better.