I'm struggling to get Excel to determine if a value is greater than or less than.
In my table, I have column F which is a date. Column G is the following formula
LEFT(F2,6)
and this formula takes the first 6 characters from F, and sticks them onto the cell in column G, giving me year and month.
All good so far. The final part is confusing me. I want to treat the values in G as a number and compare them...
So, if the value in G is the same or greater than 202206 then it should show TRUE. If not it should be false. And from the screen shot, you can see, 202201 is not greater or equal to 202206 yet, it shows it is TRUE
Column G is formatted as General
but even if I change it Number
or Accounting
the same issue persists
I also tried the following (didn't help)
= IF(G2 >= 202206)
Nor did
=IF(NUMBERVALUE(LEFT(G2,6))> 202206, "Y","N")