This technique can be used to calculate the difference between any two dates. The worked example shows calculating age and showing this in days and in whole years. It involves using the TODAY and TRUNCATE functions and nesting several functions together. Create a table for showing date of birth for required people – start this […]
You can display the weekday for dates stored in Excel. This is especially useful for checking if due dates fall during the working week. To do this you need to use the weekday function and custom formatting features of Excel. The screenshot below are from Excel 2010, but this work in earlier versions too. Ensure […]
Autofill in Excel can be used to repeat a custom sequence. Type in the entries for the sequence into adjacent cells Highlight the entries Drag down from the Autofill handle until you have the required number of entries
Autofill in Excel can be used to complete or extend any number sequence where the gap are equal. Type in the first two number of the sequence in two adjacent cells Highlight both entries Drag down from the autofill handle Drag until you reach the number of entries you require When you let go you […]
If you’re new to Excel, here’s a guide to the different mouse shapes you’ll see, and what they are used for. General Select What it looks like: Thick plus shape. When you see it: Appears when the mouse is anywhere over the worksheet grid. Why do I need it: Selecting a range of cells by […]
Autofill is a feature which will copy content down a column or accrss a row. However it also creates sequences, using the same technique, with things that it recognises as being part of a sequence. One such is dates. Enter the starting date of your sequence in Excel and ensure it is formatted as a […]
One of the most asked questions during our Excel 2010 Training Courses has to be the subject of calculating with dates. Excel stores dates (and times) as a number representing the number of days since 1900-Jan-0, plus a fractional portion of a 24 hour day (e.g. 31/10/2011 10:00 is stored as 40847.42).This is called a serial date, or serial […]