Embedding Shortcuts in Excel

Embedding Shortcuts in Excel
0.0 0

#1

Hi Guys

Quick one pls: is it possible to embed a keyboard shortcut in an excel formula.

Perfect Scenario: anytime i enter a value in Cell A1, i want Cell B1 to show today’s date (a static date “ctrl + ;” shortcut keys, so not using now() or today) - so in Cell B1 i want to use an if formula. is it possible to have something like this – =if(A1="","",“ctrl + ;”) – have tried it , didn’t work, just want to know if its possible alternative to this.

Thanks