As part of a SUMIFS formula I was hoping to use, it needs to check a column which contains a date, and only SUM if the date is within a certain month.
I was failing to get the formulae to work using < or > and a date in the formula. But if I compared it to the numerical equivalent of that date (e.g. 01May2026 is 46143), it works correctly.
The problem I'm now facing is that I can use that value "46143" if I enter it directly into the formula. But if I enter it into a cell, and use that cell in the formula, it doesn't work.
I.e:
">46143" does return all entries where the date is after 01May.
But
">A1" does not, even though cell A1 contains a value of 46143.
I can't work out why this is the case! Can anyone help? (Or just suggest a more elegant way of doing this in the first place?
Thanks in advance!
I was failing to get the formulae to work using < or > and a date in the formula. But if I compared it to the numerical equivalent of that date (e.g. 01May2026 is 46143), it works correctly.
The problem I'm now facing is that I can use that value "46143" if I enter it directly into the formula. But if I enter it into a cell, and use that cell in the formula, it doesn't work.
I.e:
">46143" does return all entries where the date is after 01May.
But
">A1" does not, even though cell A1 contains a value of 46143.
I can't work out why this is the case! Can anyone help? (Or just suggest a more elegant way of doing this in the first place?
Thanks in advance!