Excel-formula If

**europtix** · 07-27-2012, 08:52 AM

Hi

I am trying to create a formula that when someone create a cell on my excel, i want the excel automatically to create the date of the post.
I created the following formula but it seems that it doesn't work : =if(B3="*",Today(),(""))
I wanted to write : if cell B3 contain text then A3 should write the today's date otherwise it should remain empty.
Can anyone advice me who to make it to work?
Thanks

**amotto11** · 07-27-2012, 08:56 AM

try
=IF(ISTEXT(B3),TODAY(),"")
or
=IF(B3<>"",TODAY(),"")

**K m** · 07-27-2012, 08:56 AM

Try this

=if(B3="*",Today(),"")

**Roger Govier** · 07-27-2012, 09:07 AM

Hi
You cannot do this without VBA.

You could enter in A3
=IF(B3="","",today())

But, Today() is volatile, and when you open your workbook tomorrow, the date will alter.

If you are happy to use a VBA solution, then the following vent code would need to be added to your sheet.

Please Login or Register  to view this content.

To use
Copy code above
Press Alt+F11 to enter the VB Editor
Paste the code into the white pane that appears
Alt+F11 to return to Excel

You will need to save your file as a .xlsm file

See the attached file