DATE: build a date
Exercise 1 of 3
In B4, build a date from the year, month and day above.
About this lesson
DATE builds a real date from a year, a month and a day, so Excel can calculate with it.
In this lesson
- In
B4, build a date from the year, month and day above. - Excel stores a date as a number: the days since 1 January 1900. What does
=B2-B1give if B1 is 1 March and B2 is 8 March? - Invoices are due 30 days after the invoice date. In
B2, work out the due date.
Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.
fx
Type in B4 and press Enter to check.