Date Comparison

[ldoodle]

Hey,

I use this formula: =IF(TODAY()>=B3,1,0)

Only B3 contains a formula: =CONCATENATE(INT(RIGHT(Summary!$I$1,4)),"-05-01")
which causes the first formula to return 0. The calculated date in B3, in this example, is 2014-05-01. Today's date is clearly greater than this so should return 1.

If I manually type 2014-05-01 into cell B3 it works as expected. Do Excel functions read the formula, or the actual value calculated by the formula? This 'problem' suggests the former.

How can I fix this?

Thanks

 

[ldoodle]

Well that was easy. Why is it always the case that you work it out right after posting:

=IF(TODAY()>=DATEVALUE(B3),1,0)

 

[Andrew Poulsom]

Try:

=IF(TODAY()>=(B3+0),1,0)

 

[chetanmehra1989]

=concatenate(int(iferror(year(g12),right(g12,4))),"-05-01")