It would be so useful to have something similar to Excel's EDATE formula in Knack so as to be able to add or subtract a given number of months to a date value...
I realise you can do something similar using weeks and dividing by 4.3 but that is still hit and miss - a proper month function that accounts for the actual length of the months preceding and following the month in question and calculates the new date accurately would be fantastic.
As an example, if I am creating records of payment plans with a specified start date and a set number of billing cycles, this formula would be able to calculate the date of the last payment more accurately than simply using weeks/4.3