Forum Discussion
Solved
Excel - match dates in dfferent formats
Hello,
In the excel attached I am trying to sum all the dates in the second tab into a different format on the first tab.
i.e Sum of all dates in January 2018. Even when I format the dates in second tab to same format as first tab, the formula does not work.
Really appreciate support on this
Many thanks
Jenny
Sorry for the misprint. Corrected formula is
=SUMIFS(Sheet2!$D:$D, Sheet2!$B:$B,">" & EOMONTH($A26,-1), Sheet2!$B:$B,"<=" & EOMONTH($A26,0), Sheet2!$C:$C,E$1)
13 Replies
Format doesn't matter. To sum within month you may use
=SUMIFS(Sheet2!$D:$D,Sheet2!$C:$C,">" & EOMONTH(B$1,-1),Sheet2!$C:$C,"<=" & EOMONTH(B$1,0),Sheet2!$B:$B,$A2)Sorry please see attached. The highlighted cell should bring back 423. The school term is not a date. I am trying to match column B on sheet 2, with column A on sheet 1
Thank you!
Sorry for the misprint. Corrected formula is
=SUMIFS(Sheet2!$D:$D, Sheet2!$B:$B,">" & EOMONTH($A26,-1), Sheet2!$B:$B,"<=" & EOMONTH($A26,0), Sheet2!$C:$C,E$1)
