If cell A1 has text then cell B2 has today's Date

 Blocked Profile -
I'm trying to find a formula that writes,
If Cell A1 has text or any value, then B2 should show today's date and time.

Can someone help me with this please?


System Configuration: Windows 7 / Chrome 43.0.2357.81

1 reply

The format for if then is as follows: =If(logic test, true, false)

So with that in mind, you do soemthing like this (assuming a has the text to check and the check is in cell b1:

Have a go with that. You may have to format the cell into date format.

Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month