Thread: Date Formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
ozgrid.com ozgrid.com is offline
external usenet poster
 
Posts: 464
Default Date Formula

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.