Excel 2003 - Count dates

A

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.
 
P

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
 
A

Arceedee

Spot on Pete, cheers

Pete_UK said:
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
Click to expand...
 
Top