|
|
Date & Time - Dates's Formatting
Page visited 17746 times
|
1. A date is a numeric data. So it is possible to include it in a formula.
|
|
|
|
|
|
|
|
|
2. Excel provide to display a date with several format.
Sometimes you will just display the Month and the Year and othertimes the Day and the Month. But the value of the cell is always a date
|
|
|
|
|
|
|
|
|
3. In the menu Format / Cells ... you can select some standard date format
|
|
|
|
|
|
|
|
|
4. Or you can create your personnal format by choosing the Year format, the Month format and the Day format
|
|
|
|
|
|
|
|
|
5. For instance, let's work with the date of Saturday Februar 09 2002
The following array present you the different possibility to display the Day, the Month and the Year
|
|
|
|
|
|
|
|
|
6. The days
|
|
|
|
|
|
|
|
|
7. The months
|
|
|
|
|
|
|
|
|
8. The years
|
|
|
|
|
|
|
|
|
9. You could choose one of the following separator
|
|
|
Formule de la cellule
dash (-), slash (/), space ( ) |
|
|
|
|
|
|
|
|
10. To display the date February / 09 / 2002, you must write the following format
|
|
|
Formule de la cellule
|
|
|
|
|
|
|
|
11. Do the next exercise:
|
|
|
|
|
|
|
|
|
