IF function in Excel refrencing data from another cell

Posts
1
Registration date
Saturday November 24, 2018
Last seen
November 24, 2018
-
I have a column which has names (these change on a daily basis). I have dates in another cell and I want a formula that says a3="IF the date in cell A2 is TODAY, return the text from A1". Does anyone know if this possible please?
See more 

Your reply

1 reply

Posts
2440
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 13, 2018
0
Thank you
Hi Carl,

Since today's date keeps changing, using the TODAY() function won't work. So I have provided you with a macro code:
Sub RunMe()
If Range("A2").Value = Date Then Range("A3").Value = Range("A1").Value
End Sub


I'm sure this won't solve your query, so let us now how we can further assist you.

Best regards,
Trowa

Respond to TrowaD