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 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!