Excel 2003 - Count dates

[Arceedee]

Hi
I have column a in which various dates are entered. What I'd like to do is
count the number of times there is any date that falls within a given week.
e.g. say the week consists of start date Monday 12 Jan 2008 and ends Friday
16 Jan 2008 then I would like to do is calc how many times in column a there
is a date that falls into that week.
Thanks.

 

[Pete_UK]

Try this:

=COUNTIF(A:A,"<="&DATE(2008,1,16))-COUNTIF(A:A,"<"&DATE(2008,1,12))

It would be better to put your dates in other cells (eg C1, D1), then
you could have:

=COUNTIF(A:A,"<="&D1)-COUNTIF(A:A,"<"&C1)

where D1 is the later date.

Hope this helps.

Pete

 

[Arceedee]

Spot on Pete, cheers

Try this:

=COUNTIF(A:A,"<="&DATE(2008,1,16))-COUNTIF(A:A,"<"&DATE(2008,1,12))

It would be better to put your dates in other cells (eg C1, D1), then
you could have:

=COUNTIF(A:A,"<="&D1)-COUNTIF(A:A,"<"&C1)

where D1 is the later date.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete