Hi everyone,
Hope there is someone who can help me with the following problem. Please find my file attached.
I have a table that contains dates in column A and some values in column B. I am trying to add values that belong to the earliest and the latest date in a specific month and year.
Just to give you an example, the earliest day in February 2015 that I have in my table is 02.02.2015 with the corresponding value of 57. The latest day in February 2015 that I have in my table is 27.02.2015 and the corresponding value is 66. Now I need to add 57 and 66 but to do that I need to find the earliest and the latest dates, all based on the specific month and year. The first day in the month is not necessarily the 1st as much as the last day in the month is not necessarily the 28th, 30th or 31st. It all depends on available dates in column A.
Is there a way to do this dynamically, i.e. by referencing cells that contain different months and years?
Your help is highly appreciated!
Thank you!
Bookmarks