View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Arceedee Arceedee is offline
external usenet poster
 
Posts: 96
Default Excel 2003 - Count dates

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.