Solved Excel IF Statement With Date Doesn’t Work For Me

I know it’s me – I’m just not an Excel person by any stretch. So, pardon my ignorance here.

I’m trying to get a cell to do something if the current date (=TODAY() in L5) is later than a certain date. (This worksheet is for rents on an apartment building.) For example, if today’s date is June 2, I expect that all cells for Jan, Feb … June would be calculated and contain a value, and cells for Jul … Dec would be blank.

A sample formula reads: =IF(L5>4/1/16,B29+B43,””). Meaning: If the current date (L5) is greater than 4/1, then add the values from cells B29+B43 and plunk the sum in this cell. Otherwise, put a space in the cell.

But my fabulous date formula just doesn’t work. Every cell, no matter what date I test with, contains the value of B29+B43.

I’ve tried various formats for the date entry (04/01/2016, 4/1/2016) but nothing works.

Any idea what I’m doing wrong here?

Thanks in advance …