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

Solved/Closed
Sasha - Updated on Jan 21, 2019 at 10:39 AM
 Blocked Profile - Jun 10, 2015 at 05:17 PM
Hello,
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?

Thanks


System Configuration: Windows 7 / Chrome 43.0.2357.81

1 reply

Blocked Profile
Jun 10, 2015 at 05:17 PM
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:
=IF(A1<>"",TODAY(),"")

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

6