Post the *exact* formula that is returning FALSE. Neither one of David's
formulas will return FALSE!

--
Biff
Microsoft Excel MVP


"Frusterated" wrote in message
...
David,

Thanks for the advice. Unfortunately the formula only returned the word
"FALSE", which is incorrect as there is some text in the cell. Text or
no
text the result is always the word "False".

To answer your first question, I dont care if its text or numbers, as long
as its populated I would like to populate the adjacent cell with todays
date.

"David Biddulph" wrote:

=IF(ISTEXT(A1),TODAY(),"")

You haven't said what you want to do if the cell contains a number (which
is
not text and not blank).
If you want the current date for any entry (text or number), then try
=IF(A1<"",TODAY(),"")
--
David Biddulph

"Frusterated" wrote in message
...
Hello need help with a formuala. In a spreadsheet I want to check
and
see
iif a cell contains text, if so, I want to populate an adjacent cell
with
the
current date. If the cell is blank I dont want to do anything...
Thanks.