Hi Randy

Thanks for the feedback. You are more than welcome.

Try
=(AA5/A5)*(12/(Month(Today()-1))

Regards

Roger Govier


Randy wrote:
Thank you soooooo much Roger! I really appreaciate your help. I do have one
more questions that I failed to leave out and I apologize. How can I make it
subtract 1 month from the current month?