There are two other options to use the PMT function. Option one is to click the Insert Function (fx) button at the top of the spreadsheet. An Insert Function dialog box will open. In the Insert ...

The PMT function in Excel is a powerful and versatile tool for ... the month given a starting date and the number of months to add. By combining EOMONTH with the payment sequence, you can generate ...