Insert the current date in Excel – Keyboard Shortcut
- Comments Off
There are so many useful keyboard shortcuts in Microsoft Excel. Most of us have heard of ‘Ctrl‘ ‘Z‘ for undo. Perhaps ‘Ctrl‘ ‘C‘ for copy, or ‘Ctrl‘ ‘V‘ for paste. But one of the most useful ones I personally use is ‘Ctrl‘ ‘;‘ to enter the current date. Why type ‘01/15/2015‘ when you can hit two […]
Calculate Age in Excel
- Comments Off
Using a combination of built-in functions in Excel, you can quickly calculate a person’s age. There are a couple different ways this method can be used, and we’ll go through both below.
Date Formulas in Excel
- Comments Off
Some of the more common formulas I use on a regular basis are date manuputation formulas. Whether it using the Date() formula or the Month() formula or many others, there are several ways to show data that have dates involved. Let’s start by taking a look at the Date Formula itself: Date(Year, Month, Day) where […]