sum if defined date is less than or equal to current date

[Kanuck]

Hello,

I want my table to update based on defined dates. If today's date is less than or equal to my defined date, run the formula.
example: =IF(A1>=$B$1,"",SUM(C1,D1))

Cell B1 is simply =today()
Cell A1 is a future date, and once I go past it the formula runs with out issue.

The problem lies when the day is equal, the formula still isn't running. I thought this ">=" was less than or equal to, but it doesn't seem to be executing the equal to aspect.
Further to this, if I am using just "equal to" the formula is still running, which it shouldn't be if the date is not equal to the current date.

To note, even if I make it just equal to, it's still not executing the current date, but will the past dates which is very confusing.
=IF(A1=$B$1,"",SUM(C1,D1))

Any help would be appreciated, happy Friday!

Thank you,
Kanuck

[Glenn Kennedy]

Try this:

=IF(A1>=$B$1,SUM(C1:D1),"")

> is GREATER than...

[Kanuck]

perfect - thank you Glenn... knew I was close!

[Glenn Kennedy]

Yep. You were!!