Solved Excel IF statement with date doesn't work for me

April 10, 2016 at 03:15:59
Specs: Windows 10
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 ...

See More: Excel IF statement with date doesnt work for me

Report •

April 10, 2016 at 06:14:23
✔ Best Answer
If you must hard-code a date into the formula, then use the DATEVALUE() function.
The function is used to convert a piece of text into a date which can then be used in


See how that works for you.


Report •

April 10, 2016 at 07:58:03
HAH! That worked like a champ!!! Thanks so much Mike.

Report •

Related Solutions

Ask Question