I am looking for a way to calculate monthly and annual pro rata so that it automatically adjusts to the current day and month and year
eg September has 30 days and on the 15th day of the month the prorata is 50%, 10th day of september is 33% etc but when it changes to october i would like it...