View Single Post
  #3   Report Post  
micro1330
 
Posts: n/a
Default

Thank you!! I think that I asked the wrong question for what I wanted though.
Can I make this work if I want to know how many are a certain age as of
today?
Thanks again.

"Bill Martin -- (Remove NOSPAM from addre" wrote:

micro1330 wrote:
I need to set up a formula that will add up the number of people in my
spreadsheet whose birthdate is before a certain date.


If your birth dates are in column B, then:

= COUNTIF(B1:B100,"< 1/2/2001")

Bill