February 3, 2018
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?
December 7, 2016
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)
Helper column: 712
Helper column: 1012
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.