Interest Loss

[Vapour02]

Hello, I need help with a certain data. 

So for example I have multiple dates and amounts.

Date               Amount 

10/01/2022      100000

10/02/2022      200000

10/05/2022      250000

Now I need to calculate the interest loss for each amount month wise but for each day. So October month is of 31 days the amount should be calculated as 100000 * 8% / 365 * 30 ( 30 being the rest of days in the month) and for 10/02/2022 is should be as 200000 * 8% / 365 * 29 

Please help with a solution 

[Qiu · Accepted solution]

@Vapour02 
We can use the DateTimeTrim function to get the last day of the month.

[Vapour02]

Thank you so much. That worked 

[Qiu]

@Vapour02 
glad to help