Count number of cells with a date format that have a specific age range

**te31** · 10-11-2013, 04:03 PM

Hi,

I need a formula to count the number of cells in a table that have a specific age range e.g. 0-17. The cells all have the date of Birth in them, so I'm struggling to find a way to count among the whole group while also converting birth date to current age in a formula. The formula below didn't seem to work (for cells with an age of 25)

=COUNTIF($E$3:$E$16,(DATEDIF($E$3:$E$16,TODAY(),"Y")=25))

Thanks in advance!

**Ace_XL** · 10-11-2013, 04:20 PM

Try

=SUMPRODUCT(--(DATEDIF($E$3:$E$16,TODAY(),"Y")=25))

**te31** · 10-11-2013, 04:30 PM

You are a genius. Thank you so much.

Count number of cells with a date format that have a specific age range

LinkBack

Thread Tools

Rate This Thread

Display

Count number of cells with a date format that have a specific age range

Re: Count number of cells with a date format that have a specific age range

Re: Count number of cells with a date format that have a specific age range

Thread Information

Users Browsing this Thread

Similar Threads

Count number of cells with specific date and time range

[SOLVED] Can I count the number of cells in a row that have a specific format?

[SOLVED] count number occurring within specific date range

count number occurring within specific date range

[SOLVED] how 2 Count number of cells that have specific condition format?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions