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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to sync OL365 contacts and calendar to iPhone without iTunes? 1
Financial Time Value of Money calculations 5
Calculating days spent to complete a task 2
Search closest day in the past from today 2
Setting language of a selected text in Office apps. 0
Calculated % completed by date 2
Calculating Future Value 8
Space at end of multi page list to accommodate new entries 1

Top