Wednesday, April 17, 2013

yogi_Compute The Number Of Dates In Column A That Are In A Specified Year


                                          Google Spreadsheet   Post  #1140
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 17, 2013
user Nestor Torres :(http://productforums.google.com/forum/?zx=fdisqnjyvx1n#!category-topic/docs/spreadsheets/lPvlMWFdoew)

Count how many dates from an specific year are in a list
2 posts by 2 authors
 
 


Hi,

I have a list of dates, eg:

A
01/05/64
21/06/78
06/07/78
09/05/77
11/04/78
... and so on

I would like to count how many dates are from an specific year, eg: in the previous example there is 3 dates that are from the year 78. Which formula in Google Drive works to find this?

Thanx in advance.
-------------------------------------------------------------------------------------------------------------------------
following is a solution to the problem