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)
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Illogical Lucy" <Illogical
wrote in message
...
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?