Calculate items based on calendar year ending today
 

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?

Calculate items based on calendar year ending today
 

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?