I'm back with another question--this time about displaying loan payment dates based on the number of periods.
The end result I'm trying to achieve is that when some one inputs the number payment periods per year, that the spreadsheet will automatically list the dates based on the first loan payment date and number of periods. This is easy when working with individual months, quarters, or trimesters. But what about on a biweekly or weekly basis?
I know that I can use the date function to add days like this: DATE(YEAR(C24),MONTH(C24),DAY(C24)+7).
How can I get Excel to know when to automatically make the change in date format so that when you switch from 12 periods to 4 to 26 or 52 it will change the dates accordingly?
I have uploaded a copy of my spreadsheet.