Hi,
try

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

format the cell to read date

"Sara Wiseman" wrote:

If I want a cell to check to see if another cell has text in it, and then if
it does have text then it enters the date, what formula would I use? I have
part of it figured out:

=IF(ISTEXT(B2), "", "")

What I am missing is: =IF(ISTEXT(B2), "how do I get it to enter the date
here?", "")

I cannot figure out what goes inbetween the fist set of " to get it to enter
today's date. Please help me if possible, I'm going NUTS!. Thank you.

Sara