Date Formula
I don't see anything wrong with the formula.
Make sure you set your calculation to Automatic.
"Grumpy" wrote:
Please Help. I have two cells, A1, B1. In B1 I want the current date if A1
is populated. If A1 is not populated I would like the message "< Input" in
B2.
Here is my formula in B1: =IF(A1="","< Input",TODAY())
It should be so simple, but I can't seem to make it work. Can anyone tell
me what is wrong?? Thanx for your help.
|