Back to lesson
1. Which of the following functions can we use to calculate the End Date?
2. What is the purpose of the MOD function in calculating the End Date?
It ensures that the end of the period is a reporting month
It modifies the End Date to ensure that the period contains exactly the Number of Months in a Full Period
It allows us to ensure that the period doesn’t exceed the Number of Months in a Full Period
3. What is the formula for the Number of Days in a period?
End Date – Start Date
End Date – Start Date + 1
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement