Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I would like excel to return the value of the first day of each year in a column.
Assume the table below: ----A ------------------B 1 Date----------------Value 2 june 5 2000-----------82 2 august 8 2000--------120 3 december 11 2000----456 4 march 4 2002----------75 5 september 29 2002----965 The formula should return the values 82 for the year 2000 and 75 for the year 2002. The formula will be helpful as I have a list of thousands data over 20 years. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
convert day of year to numeric value format year+day in 4 digits | Excel Worksheet Functions | |||
Combination Graph with current year and prior year sales | Charts and Charting in Excel | |||
trying to get day/month/year froamt while user enters year only | New Users to Excel | |||
List First Friday's Date of the year | Excel Discussion (Misc queries) | |||
How to compare current year to prior year in bar chart? | Charts and Charting in Excel |