IF function in Excel refrencing data from another cell
Closed
carldavies75
Posts
1
Registration date
Saturday November 24, 2018
Status
Member
Last seen
November 24, 2018
-
Updated on Nov 25, 2018 at 01:14 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Dec 4, 2018 at 11:17 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Dec 4, 2018 at 11:17 AM
Related:
- IF function in Excel refrencing data from another cell
- Transfer data from one excel worksheet to another automatically - Guide
- Excel date format dd.mm.yyyy - Guide
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- Count if cell contains number - Excel Forum
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
547
Dec 4, 2018 at 11:17 AM
Dec 4, 2018 at 11:17 AM
Hi Carl,
Since today's date keeps changing, using the TODAY() function won't work. So I have provided you with a macro code:
I'm sure this won't solve your query, so let us now how we can further assist you.
Best regards,
Trowa
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