![]() ![]() Also, the weekly, monthly and annual averages should be dependent on the user picked year cell D I will likely put these averages on another worksheet and let the daily data run from A4:A covering multiple years. I need both weekly and monthly averages to ignore blanks and any text or Excel formula errors. ![]() For the monthly averages, those should be for calendar months ie. Since the year chosen for the averages could change, I need the formula to be "smart" enough to compute the first full week of any given year. So the weeks will run into the following month. And for the last week in January, starting on the 30th, the average should be representative of data from Jan 30 through February 5. So the weekly average should be from Jan 2 thorugh and including Jan 8. ![]() The first full week of January starts on the 2nd. All other weeks must start on the subsequent Sunday. In this case, the first week must be the first full week in that month that starts on a Sunday. Joined Dec 18, Messages I am trying to come up with formulas that will list the weekly dates based on the first date in the data table and compute corresponding weekly average. Thread starter dwgnome Start date Mar 26, Tags average by month weekly average. Weekly and Monthly Averages from Daily Data. For a better experience, please enable JavaScript in your browser before proceeding. If you forgot your password, you can reset your password. Excel Articles Latest reviews Search Excel articles. What's new New posts New Excel articles Latest activity. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |