If cell A1 has text then cell B2 has today's Date [Solved/Closed]

-
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
See more 

1 reply

Best answer
approved by Ratnendra Ashok on Sep 4, 2019
Posts
13034
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1527
2
Thank you
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.

Say "Thank you" 2

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

CCM 6344 users have said thank you to us this month