---
title: "Dates and DATE practice: 5 exercises with answers"
description: "Practice Excel date formulas: days between two dates, a due date with added days, DATE, MONTH and the quarter, checked in a live spreadsheet."
canonical_url: "https://excelsavvy.com/practice/dates"
meta:
  "og:description": "Practice Excel date formulas: days between two dates, a due date with added days, DATE, MONTH and the quarter, checked in a live spreadsheet."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~RGF0ZXMgYW5kIERBVEUgcHJhY3RpY2U6IDUgZXhlcmNpc2VzIHdpdGggYW5zd2Vycw%2Cdescription_~UHJhY3RpY2UgRXhjZWwgZGF0ZSBmb3JtdWxhczogZGF5cyBiZXR3ZWVuIHR3byBkYXRlcywgYSBkdWUgZGF0ZSB3aXRoIGFkZGVkIGRheXMsIERBVEUsIE1PTlRIIGFuZCB0aGUgcXVhcnRlciwgY2hlY2tlZCBpbiBhIGxpdmUgc3ByZWFkc2hlZXQu%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIl0sInJvd3MiOlt7Im4iOjEsImNlbGxzIjpbIk9yZGVyZWQiLCJEZWxpdmVyZWQiLCJEYXlzIl19LHsibiI6MiwiY2VsbHMiOlsiTWFyIDQsIDIwMjQiLCJNYXIgMTUsIDIwMjQiLCIiXX1dLCJ0YXJnZXQiOlsxLDJdfX0%2Cp_Ii9wcmFjdGljZS9kYXRlcyI%2Cs_8OjJEv5zaeFpiCXx.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "Dates and DATE practice: 5 exercises with answers"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~RGF0ZXMgYW5kIERBVEUgcHJhY3RpY2U6IDUgZXhlcmNpc2VzIHdpdGggYW5zd2Vycw%2Cdescription_~UHJhY3RpY2UgRXhjZWwgZGF0ZSBmb3JtdWxhczogZGF5cyBiZXR3ZWVuIHR3byBkYXRlcywgYSBkdWUgZGF0ZSB3aXRoIGFkZGVkIGRheXMsIERBVEUsIE1PTlRIIGFuZCB0aGUgcXVhcnRlciwgY2hlY2tlZCBpbiBhIGxpdmUgc3ByZWFkc2hlZXQu%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIl0sInJvd3MiOlt7Im4iOjEsImNlbGxzIjpbIk9yZGVyZWQiLCJEZWxpdmVyZWQiLCJEYXlzIl19LHsibiI6MiwiY2VsbHMiOlsiTWFyIDQsIDIwMjQiLCJNYXIgMTUsIDIwMjQiLCIiXX1dLCJ0YXJnZXQiOlsxLDJdfX0%2Cp_Ii9wcmFjdGljZS9kYXRlcyI%2Cs_8OjJEv5zaeFpiCXx.png"
---

> Index of every page on this site: [llms.txt](https://excelsavvy.com/llms.txt)

# **Dates and DATE practice exercises**

A date in a spreadsheet is a number of days, so you can subtract dates, add days to them and build them from a year, a month and a day.

[**Start the first exercise**](https://excelsavvy.com/practice/dates/days-between-dates)

MONTH(

## **How dates work in Excel**

Excel stores a date as a number: the count of days since January 1, 1900. That's why you can subtract dates, add days to them and build a date from separate parts. The date you see is only a number with a date format.

`**=B2-A2**` gives the days between an order date in A2 and a delivery date in B2, so Mar 3, 2024 and Mar 10, 2024 give 7. `**=A2+B2**` adds the payment terms in B2 to an invoice date to get a due date. When a system gives you the year, month and day in three columns, `**=DATE(A2,B2,C2)**` turns them into one date. `**=MONTH(A2)**` returns the month number, and `**=ROUNDUP(MONTH(A2)/3,0)**` turns it into a quarter from 1 to 4.

The usual pitfall is the format: a subtraction can show up as a date like Jan 7, 1900. Change the cell format to General or Number and you see 7. The exercises below cover days between dates, a due date, DATE, MONTH and the quarter.

1. [**1****Days between two dates**In C2, work out how many days the delivery took. Subtract the order date in A2 from the delivery date in B2.](https://excelsavvy.com/practice/dates/days-between-dates)
2. [**2****Add days to get a due date****Premium**In C2, work out the due date of the invoice. Add the payment terms in B2 to the invoice date in A2.](https://excelsavvy.com/practice/dates/add-days-to-date)
3. [**3****Build a date with DATE****Premium**The year, month and day of a date came from a system in three columns. In D2, use DATE to turn A2, B2 and C2 into one date.](https://excelsavvy.com/practice/dates/date-function)
4. [**4****Get the month with MONTH****Premium**To total sales by month you need the month number of each sale. In B2, use MONTH to get it from the date in A2.](https://excelsavvy.com/practice/dates/month-from-date)
5. [**5****Get the quarter from a date****Premium**In B2, find the quarter of the sale date in A2, a number from 1 to 4. Divide the month by 3 and round up: ROUNDUP(MONTH(A2)/3,0).](https://excelsavvy.com/practice/dates/quarter-from-date)

## **Functions in this topic**

- [**MONTH**](https://excelsavvy.com/functions/month)

## **Read the guide**

- [**Free Excel course online: learn Excel from your first formula to job-ready**](https://excelsavvy.com/learn/how-to-learn-excel)
- [**Dates in Excel: how they work and the formulas you need**](https://excelsavvy.com/learn/excel-dates)

## **Questions**

<details>

<summary>

### Why does my date show as a number in Excel?

</summary>

The cell has a number format, not a date format. Excel keeps the date as a day count, such as 45366 for Mar 15, 2024. Select the cell and choose Short Date or Long Date in the number format box on the Home tab. The value stays the same.

</details>

<details>

<summary>

### How do I calculate the number of days from a date until today?

</summary>

Subtract with TODAY: =TODAY()-A2 gives the days since the date in A2, and =A2-TODAY() gives the days left until a date in the future. TODAY updates every time the workbook recalculates, so the answer changes from day to day. Format the result cell as General or Number.

</details>

<details>

<summary>

### Why can't Excel calculate with my dates?

</summary>

The dates are probably text. Text sits at the left edge of the cell, while real dates line up at the right. Try =DATEVALUE(A2) to turn a text date into a real one, or retype the date in a format your Excel recognizes. Then subtracting and adding days works.

</details>

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://excelsavvy.com/#identity","@type":"Organization","name":"ExcelSavvy","url":"https://excelsavvy.com/","logo":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/#website","@type":"WebSite","inLanguage":"en-US","name":"ExcelSavvy","url":"https://excelsavvy.com/","alternateName":["Excel Savvy","ExcelSavvy.com","PracticeExcel","Practice Excel Online"],"publisher":{"@id":"https://excelsavvy.com/#identity"},"workTranslation":[{"@id":"https://excelopgaver.dk/#website"},{"@id":"https://excelpraxis.de/#website"}]},{"@id":"https://excelsavvy.com/practice/dates#webpage","description":"Practice Excel date formulas: days between two dates, a due date with added days, DATE, MONTH and the quarter, checked in a live spreadsheet.","name":"Dates and DATE practice: 5 exercises with answers","url":"https://excelsavvy.com/practice/dates","@type":["WebPage","CollectionPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/practice/dates#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/practice/dates#/schema/question/1"},{"@id":"https://excelsavvy.com/practice/dates#/schema/question/2"},{"@id":"https://excelsavvy.com/practice/dates#/schema/question/3"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/practice/dates"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/practice/dates#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Excel practice exercises","item":"https://excelsavvy.com/practice","position":2},{"@type":"ListItem","name":"Dates and DATE practice: 5 exercises with answers","position":3}]},{"@id":"https://excelsavvy.com/practice/dates#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"Why does my date show as a number in Excel?","acceptedAnswer":{"@type":"Answer","text":"The cell has a number format, not a date format. Excel keeps the date as a day count, such as 45366 for Mar 15, 2024. Select the cell and choose Short Date or Long Date in the number format box on the Home tab. The value stays the same."}},{"@id":"https://excelsavvy.com/practice/dates#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"How do I calculate the number of days from a date until today?","acceptedAnswer":{"@type":"Answer","text":"Subtract with TODAY: =TODAY()-A2 gives the days since the date in A2, and =A2-TODAY() gives the days left until a date in the future. TODAY updates every time the workbook recalculates, so the answer changes from day to day. Format the result cell as General or Number."}},{"@id":"https://excelsavvy.com/practice/dates#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"Why can't Excel calculate with my dates?","acceptedAnswer":{"@type":"Answer","text":"The dates are probably text. Text sits at the left edge of the cell, while real dates line up at the right. Try =DATEVALUE(A2) to turn a text date into a real one, or retype the date in a format your Excel recognizes. Then subtracting and adding days works."}},{"@id":"https://excelsavvy.com/#logo","@type":"ImageObject","caption":"ExcelSavvy","contentUrl":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3","inLanguage":"en-US","url":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3"}]}
```

## Sitemap

See the full [sitemap](https://excelsavvy.com/sitemap.md) for all pages.
