Rate End Date Calculator

The Rate End Date Excel Calculator you know, but improved!

Written By Systems Admin (Super Administrator)

Updated at May 15th, 2026

 

 

Remember that the rate end date is always based on the financial move-in date (accommodation start date). Pay special attention to your entries if the financial and the physical move-in dates are in different months.

Example: If financial move-in is in late-January, but physical move-in isn't until early February, the rate end date is still January of the following year. See below images from Term and Accommodation steps, respectively.

Term Start Term End Example
1st of the Month End of previous month the following year April 1, 2023 - 
March 31, 2024
2nd - End of Month End of same month the following year April 11, 2023 -
April 30, 2024