TRID Date Calendar

Confused by the TRID date rules? Based on the application date, when is the Loan Estimate required to be delivered, when is it considered received, how do Changed Circumstances change things, when are Closing Disclosures required and when can you close the loan?

BOL user Carolina Blue created a calendar tool in Excel. There are two tabs:

• one for calculating the earliest possible closing date based on when the Loan Estimate(s) and Closing Disclosure are issued/received and
• one provides the latest possible date the Loan Estimate(s) and Closing Disclosure can be given to meet a desired closing date.

Select which tab you want and complete the green fields (and one yellow field) when prompted.

NOTE: The password to unlock both tabs is TRID in the event you need to customize this tool. You will need to have Excel 2010 or later for the tool to work properly.

TRID (v4) is contributed by "Eldon96" and is an enhanced version for use especially by those with older versions of XL or who don't have the ability to work with add-ins on the XL program itself. Saturdays can be selected or deselected, using Y or N in the Holidays tab. No add-ins are required. For those wondering what the differences are, this includes day calculations in the hidden columns that take the place of the workdays.intl() and networkdays.intl() functions added in XL versions 2010 and above. It’s a simple solution and only wouldn’t work if there were more than 3 days back to back that were Sundays and holidays. A third sheet was added with the holiday list rather than have two hidden lists for each sheet. It’s protected but not hidden.

Beginning with TRID (v4.3) we've included Juneteenth, June 19 of each year beginning in 2021, as a federal holiday.

Version 6.1 has been added to include Oct 2017 thru 2023 holidays. What changed this year was "Earliest Closing Date" cell A24 was changed to read, "Enter evidenced date of CD receipt. If not a business day, choose the next business day." The "choose next business day" was added. One mortgage lender commented that it is common for a borrower to get the CD on a holiday, and she insisted this should be the next business day in the box to avoid potential errors. This should allow the Earliest Closing Date tab to match the Desired Closing tabs results. Also, cell B28 on the "Desired Closing" tab was supposed to be locked. It was also supposed to have a formula in it. Here in version (6.1) where I added that formula back in as it was removed in v6.

**Users need to verify the complicated TRID requirements when a static date holiday falls on a Sunday. As an example in 2022, June 20, 2022, is a business day based on the precise definition; it is not counted as a holiday for the precise definition. If the bank is open for substantially all business, it is counted as a business day using the non-precise definition. If an application is received 6/16/22, the LE must be sent by 6/21 if the bank is not open for business on Saturdays but is open on the 20th. But by 6/22 if the bank is closed Saturdays and not open on 20th.

As always, these and our other tools are not guaranteed and the user is ultimately responsible for ensuring their dates are compliant with the regulatory requirements applicable.