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
|