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

Jun 5 2007

Today() Formula in Excel

A common excel formula that can come in handy in many projects with Excel is the Today() Function. The Today() Function is used to return the serial number of the current date. By formatting the cell where the formula is used, it will return the Month, Day and Year of today. One of the easiest […]

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks

Categories

Archives