Calculate Days Between Dates

Subtract one date from another to count the days in between.

You will learn to

• Understand dates as serial numbers
• Subtract dates

How it works

Excel stores dates as serial numbers (days since 1900), so subtracting two dates gives the number of days between them: =C2-B2. The DAYS function does the same: =DAYS(C2,B2).

=C2-B2