I have a Excel report, where i can add the detail into the Daily tab,
But ideally i would like to add a formual to the Monthly and Weeky tabs so that
the Weekly Tab will just sum up those daily entries that represent that week
and the Monthly tab will sum up the daily entries that represent that month.
Is this possible?
I don't mind having to copy and past the formula into the cell of the weekly or monthly for the whole week.
I'm just not sure how can i predict for
The monthlies that it only looks at the entires on the daily tab for the monthlies.
and for teh weeklies that it only looks at those 7 entries on the daily tab for that week.
the example ive attached is very small. my actually file has many many rows and so each week i spend at least an hour updating the forumlas to correct this.
If anyone can please advise?