|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 ...