Formula - 2018 dates not calculating but 2017 are

[Sg327]

I am at a complete loss - The below formula was working fine until this year.

=SUMIFS(Heartland[[Disputed Amount ]], Heartland[[Tran Type ]], "Chargeback of Sale ", Heartland[[RC ]], "83", Heartland[[IC Date ]], ">=" & C4, Heartland[[IC Date ]],"<=" & C5) +SUMIFS(Heartland[[Disputed Amount ]], Heartland[[Tran Type ]], "Chargeback of Sale ", Heartland[[RC ]], "7030", Heartland[[IC Date ]], ">=" & C4, Heartland[[IC Date ]],"<=" & C5) +SUMIFS(Heartland[[Disputed Amount ]], Heartland[[Tran Type ]], "Chargeback of Sale ", Heartland[[RC ]], "4837", Heartland[[IC Date ]], ">=" & C4, Heartland[[IC Date ]],"<=" & C5)


I created formulas to link from a separate spreadsheet to sum "Disputed Amount"

if a cell in column "Tran Type"= "Chargeback of Sale", also​

if a cell in column "RC" = 83,7030, or 4837 and also if the column "IC Date" falls with in the date range typed into C4 & C5

This is working fine for dates in the year of 2017 - but for what ever reason will not calculate at all if the date range entered is in the year 2018.

 

[steve the fish]

Hi. Im pretty sure its nothing to do with the date as such being 2018. It looks like you are working on a text file. Lots of trailing spaces and textual numbers. That makes me think the date may be textual as well. Excel wont see this as the date. Try highlighting the column with the date in it, pressing text to columns and then finish.