Number of Specific Day within Dates

  • Thread starter Thread starter Abdul
  • Start date Start date
A

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,
 
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....
 
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,
Click to expand...

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)
 
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)
Click to expand...

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
 
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 -
Click to expand...

Thanks. That was much better.
 
Back
Top