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 to calcualte based on 31 days etc
for the annual pro rata i am looking for the same thing so that it calcualtes in any given year the prorata of the current date.
Is a variation of networkdays the answer?
hope this makes sense and thank you
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 to calcualte based on 31 days etc
for the annual pro rata i am looking for the same thing so that it calcualtes in any given year the prorata of the current date.
Is a variation of networkdays the answer?
hope this makes sense and thank you