Excel 2003 - Count dates
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
On Jan 28, 4:49*pm, Arceedee
wrote:
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.
|