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 quantity and divide by the current number of days from the beginning of the current year?
For example, say I have a total of 45,660 parts sold YTD as of April 22 2024. The average daily sales of that would be 45,660/112=407.7. Would I be able to use a function that would automatically change the 112 value to 113 as the calendar day advances?
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 quantity and divide by the current number of days from the beginning of the current year? For example, say I have a total of 45,660 parts sold YTD as of April 22 2024. The average daily sales of that would be 45,660/112=407.7. Would I be able to use a function that would automatically change the 112 value to 113 as the calendar day advances? Read More
