I have a table with all customers to be invoiced. They are to be invoiced monthly on a set date. I have a data creation date as well as the day to be invoiced (i.e. every 25th of the month, the fields is only 25)
I want to create the following: from the creation date (for example may 10th), create the next date that is day 25 (therefore may 25th).
You should be able to do this in a formula by taking the Month and Year of Created Date, then smashing that together with 25 as the day. Probably a good idea to then turn that into a date format so you can use it later.