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 the current date and time in cell a1
Excel if cell contains date then return value - Best answers
If cell contains date then return value - Best answers
Trying to have the current date go into one cell (A1) ✓ - Excel Forum
Disk boot failure insert system disk and press enter - Guide
Which function will you use to enter current time in a worksheet cell ✓ - Office Software Forum
If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
Activeworkbook.worksheets current worksheet ✓ - Excel Forum

1 reply

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!