Hi, I have a table as below. I would like to add another column to calculate average cumulative closing rate daily whenever a new closing rate is entered. The cumulative average needed to be reset whenever the month changed. User will manually key in date, month and closing rate.
Date...