I Illogical Lucy May 6, 2009 #1 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?
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 May 6, 2009 #2 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)
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)
