Is it possible to nest an IF statement in Excel using the current date as the variable?
I’d like to tell it "If today’s date is greater than the date in this cell, mark the cell with this symbol, else mark it with this symbol" I sort of understand how to do IF statements with data from different cells, I just wasn’t sure if you could have it query the system time and use that.
Rooch answered what my original question was. Now I’m wondering if it’s possible to add an exception like "if today’s date is greater than the date in B3, mark it with this symbol, UNLESS the date in B4 is less than or equal to the date in B3". I know that’s asking a lot =) Basically I have a column indicating a due date, a column indicating the received date and a column indicating whether it was on time or not. I could tell it to check today’s date vs the due date, but that doesn’t account for the received date. If I don’t add the exception, it will mark them all as overdue as soon as the due date passes. I hadn’t thought about that when I asked the question =)
This will work…
=IF(TODAY()>C5,"true","false")
August 14th, 2009 at 8:41 am
This will work…
=IF(TODAY()>C5,"true","false")
References :
August 14th, 2009 at 8:53 am
You can tell it "If today’s date is greater than the date in THAT cell, mark this cell with this symbol, else mark it with this symbol", but you can’t have a formula modify the data in the cell the formula is in; that’s called a circular reference, and it’s illegal. (After your way ran, the data in the cell could be "this symbol" [whatever symbol you used], rather than a date, which would make the formula blow up.)
You COULD do it with a macro, but it would only run once. Again, once the data in the cell was changed to your symbol, running the macro on that cell would throw an error (type mismatch).
References :