View Single Post
  #1   Report Post  
Guym Guym is offline
Junior Member
 
Posts: 4
Default Value of the first day of a year in a list

I would like excel to return the value of the first day of each year in a column.

Assume the table below:
----A ------------------B
1 Date----------------Value
2 june 5 2000-----------82
2 august 8 2000--------120
3 december 11 2000----456
4 march 4 2002----------75
5 september 29 2002----965

The formula should return the values 82 for the year 2000 and 75 for the year 2002. The formula will be helpful as I have a list of thousands data over 20 years.

Thank you