MS 2010 - IF Statement to reutrn date or leave cell blank

[persais]

Hi there,

I'm sure this is a very simple solution but I can't seem to put them together, I am trying to say that if a cell contains text then return todays date, if no text leave blank, here is what I have tried.

=IF(ISTEXT(C11094),"=NOW()","")

Meaning if there is text in that cell return todays date, if no text leave blank. I may be way off base too.. Any help is much appreciated!!

[rcm]

Please Login or Register  to view this content.

[Pete_UK]

You were nearly there:

=IF(ISTEXT(C11094),NOW(),"")

If you only want the date, though, it would be better to use TODAY() instead of NOW(), and I would write it like this:

=IF(C11094="","",TODAY())

with one less function call.

Hope this helps.

Pete

[persais]

Thank you!!! yes that does the trick exactly, have a very wonderful day!