Forum Discussion
Formula needed to calculate average over current day in year
I'm looking for a formula to calculate a year-to-date daily average using Excel that would automatically change the amount of days as time goes on. Is there a function that can use a YTD sales quanti...
Good Morning
The question asked regarding the YTD worked perfectly. How can this be done as a MTD format?
Thanks
Neil
The number of days in the current month up to and including today is
TODAY()-EOMONTH(TODAY(), -1)
So you can use
=MTD_Quantity/(TODAY()-EOMONTH(TODAY(), -1))
This assumes that you have a named range MTD_Quantity.
Thank you for the assistance - this should definitely work.