Back to lesson
1. What happens when a date is formatted as a number, and why?
Nothing, because it's a date rather than a number.
The date turns into a number representing the number of days elapsed since January 1, 1970.
The date turns into a number representing the number of days elapsed since January 1, 1900.
2. Which formula is used to generate the current date?
3. What does the formula =MONTH(DATE(2013,12,11)) return?
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement