Calculate items based on calendar year ending today

I

Illogical Lucy

How can i set up a formula or spreadsheet to calculate how many item have
occurred in the last year based on today's date?
 
N

Niek Otten

One way:

Insert a column in which you extract the year from the dates:
=YEAR(A1), fill down
Then SUMIF on that column:
=SUMIF(B1:B7,YEAR(TODAY()),C1:C7)
 
Top