Jan 15 2015

Insert the current date in Excel – Keyboard Shortcut

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 […]

Aug 2 2011

Calculate Age in Excel

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.

TAGS: , ,
Apr 26 2007

Date Formulas in Excel

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 […]

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks