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...
The number of days in the current year up to and including today is
TODAY()-DATE(YEAR(TODAY())-1, 12, 31)
So you can use
=YTD_Quantity/(TODAY()-DATE(YEAR(TODAY())-1, 12, 31))
Good Morning
The question asked regarding the YTD worked perfectly. How can this be done as a MTD format?
Thanks
Neil