I have a table col A has the date, col F has the daily total that I have earnt.( see sample attachment)
I would like a formula that can be used in col G to show my weekly totals - with weekday starting on a sunday (The week can roll over into the new month if that happens to occur )
and a formula in col H to show my monthly totals (Starting on the first date of that month and ending on the last date of that month.)
NOTE: In the sample I have just used a basic sum just to show you how I would prefer it to be results to be displayed. Wondering what formula I can use to do this all automatically instead of making a bunch of simple sums here and there.
If I have to make a new table for the weekly/monthly totals that's ok just not prefered.
Any help with some correct formulas for this would be greatfully appreciated.
Bookmarks