Annual compound interest calculation - dynamically updates on a given period using Power Query and shows monthly until the last selection date.

Power Query

Last Post by Alan Sidman 9 months ago

3 Posts

3 Users

0 Reactions

25 Views

RSS

Samuel John

(@sam_myonline)

Posts: 1

New Member

Topic starter

I would like to know how to get the updated interest calculation using Power Query for the given example below when choosing the date in E5, and it should be reflected monthly for recording. I used the formula in cell E17 =FV($E$3,DATEDIF($C7,E$5,"D")/365,,-$D7)-$D7

Please see the attachment

Thank you

Samuel

Posted : 06/05/2024 6:46 am