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 allows us to ensure that the period doesn’t exceed the Number of Months in a Full Period
It modifies the End Date to ensure that the period contains exactly the Number of Months in a Full Period
It ensures that the end of the period is a reporting month
3. What is the formula for the Number of Days in a period?
End Date – Start Date + 1
End Date – Start Date
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement