Hello, I would like to create a formula that works out a date period for example the start date is 11/12/20 and 4 months later (calendar months) ie 11/04/2020 is there a formula I can use to automate this date of the 11/04 from my start date?
Thanks
Nathalie_Collins:
DATETIME_FORMAT(DATEADD({Start Date},4,'month'),'DD-MM-YY')
Thank you, this worked! How would I could I also use a date formula on this example?
A loan is due to redeem on 11/12/20 - from the 12/12 the interest rate is highe...
