Back to lesson
1. Assuming there is a valid date in B9, what formula would we use to work out the end of that month?
2. Assuming there is a valid date in B9, what formula would we use to work out the same day from the prior month?
3. What will EDATE(DATE(2012,2,29),12) return?
Feb 28, 2013
March 1, 2013
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement