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.
If cell contains date then return value - Best answers
Excel if cell contains date then return value - Best answers
How to insert a checkmark in word - Guide
The page cannot be displayed. (80710a06) - PS3 & PS4 Forum
How to insert photo in word for resume - Guide
Based on the cell values in cells b77 ✓ - Excel Forum
Insert draft watermark in word on all pages - Guide

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!