FIX: Arrow Keys Navigation does NOT work in Excel

Issue: The arrow keys navigation does not work in Excel application on your system. The same arrow keys navigation just works fine in other applications. Solution: You probably have the Scroll Lock special key pressed/enabled on your keyboard which causes this behaviour.  To fix click on Scroll Lock special key to release/unlock/disable it. The Scroll […]

Excel Formula to calculate Number Of Days in a Month

Requirements: You want to build a calculator sheet that requires you to input number of days in a given month. Solution: Excel doesn’t have any built-in function to return the number of days in a month.  I’ve learned below two formulas that does the job. Both of them requires a date input and will return […]