Microsoft Excel
Microsoft Excel is a spreadsheet program that allows you to create several workbooks with charts, formula’s and several other features.
Calculate the Amount of Time Between Two Dates in Excel 2003
To calculate the number of days between two dates, you can simply subtract the two dates. For example, if cell A1 contains the date 6/8/2000 and A2 contains 6/20/2000, the formula =A2-A1 calculates the number of days between these dates (12).
Be sure to use number format for the cell where you enter this formula (click Cells on the Format menu, click the Number tab, and then click Number under Category). If you don't format the cell with number format, Excel assumes the result has the same format as the cells used in the calculation, and displays the result as a date instead of a number.
A very helpful tip: To calculate how old someone is. The example below shows you the DOB, birthday this year and there current age. To do this, type the date of birth in cell A1 and type the date of birth for the current year in cell A2. In cell A3 type the following formula: =-(A1-A2)/365 press enter. You can practice this by using you birthday, the following example shows my birthday and age.
