Back to lesson
1. If you format a date as a number, what will happen and why?
Nothing, because it is a date, not a number.
It will turn into a number representing the number of days elapsed since Jan 1, 1970
It will turn into a number representing the number of days elapsed since Jan 1, 1900
2. What formula should be used to generate the current date?
3. What would be returned from the following function? =MONTH(DATE(2013-12-11))
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement