Your formulas works for me. Be aware though, ="" is NOT the same as A1 being
empty as a formula (in which case the cell is not empty) can return ""
(empty text). You MIGHT need;
=IF(ISBLANK(A1),"< Input",TODAY())
--
Regards
Dave Hawley
www.ozgrid.com
"Grumpy" wrote in message
...
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.