Hi,
I am preparing a model which requires me to sum the data based on month and day only. Eg. sum between two dates (7/12/19 to 10/12/19) without considering the year, meaning, sum between 12th July to 12th October. Would you please suggest me the way to solve this problem?
Thank You.
Hello,
What is the issue? What formulas have you tried with?
In general, if the year is irrelevant, add a helper column which takes the month and day value from the date and sum the data based on the helper column.
Example formula to populate the helper column where first date value is in cell A2: =MONTH(A2)&DAY(A2)
Date: 7/12/19
Helper column: 712
Date: 10/12/19
Helper column: 1012
Date: 7/12/20
Helper: 712
Then you can use a formula based on the helper column, i.e. greater than 711 AND less than 1013.
If you provide a sample file showing your data and structure you might get a better and more spot on answer.
Br,
Anders
