In excel I have a spread sheet that I use to calculate payment dates for students doing standing orders. I enter the date the student enrolled and would like it to calculate the start date of the standing order. All standing orders are paid on the 15th of each month. For example if a student enrolled on the 5th September it must show the 15th October as the payment date, if enrolled on the 5th October must show 15th November. If they enrol earlier than the 5th it must show the 15th of the same month. Hope that makes sense! Any ideas?
Bookmarks