What if there is a way to define new formulas in Excel without using VBA? One would be very skeptical of any such claims. But, believe it or not, it is true. Think about how easy such a technique would make your life. Not only would it allow you save a lot of time, the technique is also very handy in simplifying or restricting complex formulas to stop your audience from making blunders while using your files. Moreover, it’s extremely simple to do!
Our very own Excel expert Szilvia Juhasz has uncovered this life-saving functionality for the fans, giving us all the more reasons to thank her.
We all are aware of how we can name ranges using the Name Manager. Let’s review it:
There are 2 apparent advantages of using named ranges.
Also, if we give meaningful names to our ranges, worries about getting confused or memorizing the names go out the window.
The trick uses the Name Manager and some ingenuity. Let’s take an example: we have the formula TODAY() in Excel which returns today’s date. But we do not have a corresponding equivalent for yesterday, or even tomorrow for that matter. Well, with this trick, we do.
Go to any cell and type “=Yesterday”. And, there you have it!
Note that you do not need any parentheses in this case. Also, set the cell to any date format for it to appear like we would want.
Try it out! Now try it some more. Let’s make our lives simpler. And, share, share, share! Help the knowledge of your friends and colleagues grow.
Also, do comment below about any creative uses of this technique you might have come across.
Please log in again. The login page will open in a new window. After logging in you can close it and return to this page.