Calculating with dates

BeginnerBeginner

10 questions, about 14 minutes

To Excel, a date is just a number. That's why you can calculate with it.

What we'll do

  • Understanding serial numbers
  • Adding and subtracting days

What you'll use

  • DAYS
  • INT
  • IF

How it works

In an example you watch and don't need to fill anything in. You answer a question yourself. If it goes wrong, you get a tip, then a hint and finally the solution.

2examplesYou watch
10questionsYou do it yourself
Full explanation