There are a couple of ways to pull this off. One is to wrap another DATEADD() function around the existing one and add five days. However, another option is to switch from months to days, and add 35 days total:
Yea sure, so a tenants rent is due every month and the rent due date is updated to the next month on the day it is due from March 11,2021 to April 11,2021 etc I would like to still see the due date on the day the rent is due which is March 11,2021 and it still remains March 11, 2021 for 5 days and then gets updated to April 11, 2021.
Ah, gotcha. That’s definitely more clear, but also more challenging. At first I thought I would need a day or two to mull it over, but inspiration hit and I got it working. (I start the formula with the IF() function just to prevent error messages with no contract date entered, and I split it across multiple lines because it got too hard to keep track of otherwise.)