I am trying to get my amortization schedule working in real time with current and future figures.

in cell M24 it shows the date in B24 which is correct and shows 16/12/2021

=IF(N24="","",IF(B24<>"",B24,WORKDAY(EOMONTH(O$18,ROW(B24)-6)+7,6)))

however M7 needs to show the date M6+1 month (workday only)

=IF(N25="","",IF(B25<>"",B25,(WORKDAY(EOMONTH(O$18,ROW(B25)-6)+7,6))))

this shows 15/05/2023

So in short I would like the date in column M = the same line in Column B if B has a date otherwise I would like M to show the previous date in M plus 1 month and not landing on a weekend.

so if N24 is blank then blank, otherwise if B 24 is not blank then show the value (date) in B24 otherwise show the previous date (M5) plus 1 month (only days monday to Friday).

so the formula (=WORKDAY(EOMONTH(O$18,ROW(B25)-6)+7,6))) worked before I had it look at column B and works in relation to B but not the first time B is blank.

Sorry John

oh and actual bank Amortization is on TAB bank.

My partner wants to see real time amortization and future.

**EDIT**

sorry uploaded correct file.