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

If cell contains date then return value
Insert a function in cell b2 to display the current date from your system. - Best answers
Excel if cell contains date then return value - Best answers
If cell = date return yes or no. ✓ - Office Software Forum
Excel: If Date =, then enter a value ✓ - Excel Forum
Excel "IF" function w/ date in test cell ✓ - Excel Forum
Excel formula to check if cell contains a date - Excel Forum
If a cell has text then return value ✓ - 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!