How do I count the number of dates in a column within a specific year range (i.e. 1980-1984)? [closed]

asked 2019-06-10 15:24:06 +0200

Phaz gravatar image

The end game is to produce a monthly graph of the demography of the ages of the members of the club I volunteer for. Once I can select the data I need, the rest I can do. I have around 400 members. I have a spreadsheet containing the ages of the members which are in Date format (13/12/1999). I believe the correct function to use is COUNTIFS(). If the date was just the year in number format I could use:- =COUNTIFS($'Member DB'.F2:$'Member DB'.F400,">=1980",$'Member DB'.F2:$'Member DB'.F400,"<=1984") What I can't fathom out is how to manipulate the "Date" field to allow me to select the various date(year) ranges that I need. Any help will be gratefully received. Phaz

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Phaz
close date 2019-06-11 15:15:41.754759

Comments

1

">="&DATE(1980; 1; 1); "<"&DATE(1985; 1; 1)

Mike Kaganski gravatar imageMike Kaganski ( 2019-06-10 16:01:08 +0200 )edit

Thanks Mike.

Phaz gravatar imagePhaz ( 2019-06-11 15:15:07 +0200 )edit