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...
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)
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)