Thread: Date count
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Syahira
 
Posts: n/a
Default Date count

Hello everybody :-)
Let say I have these data:

Centre Name Date Open
Santa Maria August 2004
St. Loius April 2006
Greenlane March 2002
North Point December 2005
South Point May 2006

This is a part of the data that I have.

My question a
1) How to count how many centre open before 2006?
2) To list the centre open before/after 2006
3) To list of centre that have operated 1 year or more?

Thanks (^_^)