Excel-Exercise-Free

1. A date is no more and no less that a number. Excel enumerates the days from 01/01/1900 and display the result as a date.

2. For instance, February the 09 2002 is indeed, the figure 37296

3. To display only the day of a date, you have to write the following formula

Formule de la cellule

4. To display the month, you have to use the next formula

Formule de la cellule

5. And for the years

Formule de la cellule

6. Now, you want to create a document with date in the headline.
These dates represente the month and instead of fill each cells, you will create a formula do to it automaticaly

7. In the first cell, you write the current date and change the format to display only the month and the year

Formule de la cellule

8. To add 1 month to the previous date, you need to break up the previous date in day, month, year and add 1 to the previous month..

In B1 the formula is:

Formule de la cellule

9. In this exercise, you have to calculate the first and the last day of a month, whatever the month