Calculating the number of days between two dates is just like any other calculation. Microsoft Excel treats dates like numbers. The number 1 is 1 January 1900, 2 is the 2 January 1900 and so on. This is important to understand when working with dates.

Knowing this Excel can then find out how many days are between two date using subtraction.

A2 = 23 December 2011
B2 = 20 December 2011

the calculation is C2 is =A2-B2

The answer would be the number of days between the two dates. These are days not weekdays in order to calculate the number of weekdays you would have to use a function, a word that performs a calculation (Sum is one but not the right one for this type of calculation).

We will look at that another day.