Automating out current loan period from start date and todays date in IMPT function

Hey

After a bit of help if I may

Trying to automate the period part of the impt function

To calculate current value of loan i have the below formula below with the 3 being the current period

=IPMT(4.3%/12,3,5*12,-7000)/(4.3%/12)

What i would like to do is for the period to be self calcuating from current date and the loan start date. I can return a value in days using start date - today() and aware month function returns the month number but stuggling to find a way to work out cumulative month from the start date

Any help would be greatly appreciated

Regards

Richard

Thanks but can not find function datedif? Anything i need to turn on to enable it?

Richard

Thanks so much for your help. Now works perfectly

Didnt work initially but realised that the value was returning zero. Once the value ticks over to 1 works perfectly.

Richard