| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Amount Based on Year | Excel Worksheet Functions | |||
| How to calculate based on Validation LOV items? | Excel Worksheet Functions | |||
| Calculate a date based on period and year | Excel Worksheet Functions | |||
| calculate prior calendar year end from a moving current date | Excel Worksheet Functions | |||
| import calendar items from excel into outlook calendar | Excel Discussion (Misc queries) | |||
Linear Mode
