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

Report
-
 Blocked Profile -
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


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.

2
Thank you

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

CCM 3116 users have said thank you to us this month