Back to lesson
1. If you format a date as a number, what will happen and why?
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
Nothing, because it is a date, not a number.
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