Thread: Date Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default 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.