MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### Count specific days in between dates

• Follow

```Hello,

I am trying to count a specific number of days in between 2 dates. For
example, if I specify a certain date range of:
Start Date: 01/01/2010
End Date: 12/31/2010

and my fixed days are:
01/02/2010
04/01/2010
02/01/2011

then the formula would return: 2

I guess this would be similar to counting the number of holidays within a
given date range. Any suggestions would be very much appriciated.

```
 0

```Hi,

Start date in A1, End date in a2 and the days to count in B1:B3

=SUMPRODUCT((B1:B3>=A1)*(B1:B3<=A2))

--
Mike

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

"Gabe" wrote:

> Hello,
>
> I am trying to count a specific number of days in between 2 dates. For
> example, if I specify a certain date range of:
> Start Date: 01/01/2010
> End Date: 12/31/2010
>
> and my fixed days are:
> 01/02/2010
> 04/01/2010
> 02/01/2011
>
> then the formula would return: 2
>
> I guess this would be similar to counting the number of holidays within a
> given date range. Any suggestions would be very much appriciated.
>
```
 0

```Thank You!

"Mike H" wrote:

> Hi,
>
> Start date in A1, End date in a2 and the days to count in B1:B3
>
> =SUMPRODUCT((B1:B3>=A1)*(B1:B3<=A2))
>
> --
> Mike
>
> When competing hypotheses are otherwise equal, adopt the hypothesis that
> introduces the fewest assumptions while still sufficiently answering the
> question.
>
>
> "Gabe" wrote:
>
> > Hello,
> >
> > I am trying to count a specific number of days in between 2 dates. For
> > example, if I specify a certain date range of:
> > Start Date: 01/01/2010
> > End Date: 12/31/2010
> >
> > and my fixed days are:
> > 01/02/2010
> > 04/01/2010
> > 02/01/2011
> >
> > then the formula would return: 2
> >
> > I guess this would be similar to counting the number of holidays within a
> > given date range. Any suggestions would be very much appriciated.
> >
```
 0

2 Replies
1007 Views

Similiar Articles:

7/22/2012 7:43:29 PM