Using dates as conditions to select whether or not the 'sum' includes the cost column

Hi all,

Thank you in advance for your help. This is a multi-part formula that I need to work out and I keep running into brick walls, not least because of the way Excel reads dates (I'm UK based). The information is also spread across several worksheets and the sum total is on a results page at the end.

What I'm trying to do is to work out whether a maintenance cost should be included in a sum column. The condition for this is whether it is due to be replaced by the end of the season for us (31st August). So the trail is - if [due date] is before [end of year date], include contents of [maintenance cost] cell for that row to the sum total on the results page. At the moment I'm working to =IF('worksheet! date cell'<31/08/2023, 'worksheet! replacement cost cell (for if the 'true' value), 0 (for the 'if false' value).

E.g.: =IF('Site1'!B1<31/08/2023,'Site1'D2,0). This is just returning a value of 0 even though the value I have in B1 is 16/08/2023, so 'less than' 31/08/2023. I'm working on Excel online if that has an effect although I can shift offline.

Can anybody please point out what I'm doing wrong?

Try:

Formula:

Please Login or Register  to view this content.

You're welcome.


You may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.