IF() formulas for monthly or bi-weekly periods

Now that we know how to calculate dates for bi-weekly and monthly interest periods, it's time to use that to calculate dates in 2 separate ways.

For monthly calculations, you will use the EOMONTH() function to calculate the last day of the month for several periods in advance. For bi-weekly calculations, you multiply the number of periods by 14 then add back to the start date.

In this exercise, the IF() function is already filled in column F - you only need to fill in the period type, the number of periods and the EOMONTH() or days added. When you are done, the end date in column F should equal the expected date in column G.

There are no cases in this exercise where a bi-weekly payment will be on the last day of the month.