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

Insert a function in cell b2 to display the current date from your system.
Insert the current date and time in cell a1 - Best answers
Insert the current date in cell a1 - Best answers
What is the function of a hard drive - Guide
Where is the insert key - Guide
How to insert at the rate in laptop - Guide
Insert check mark in word - Guide
Based on the cell values in cells b77 ✓ - Excel Forum

1 response

Answer 1 / 1

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.

Similar discussions

Counting number of times a value appears if..

Copy data onto sheet only if cell has text

help me to add particular cells

Excel if range of cell contain a text put a cell value in

Excel - IF function with multiple words

If cell = date return yes or no.

Similar discussions

Subscribe To Our Newsletter!