Weekly Subtotal in Excel
I am working with a spreadsheet that tracks a detailed history of various
financial transactions in a workweek. Column A displays the date in day form (€˜Wednesday, €˜Thursday, etc.), Column B is the date in date format, Columns C through F are the various transactions, and Column G is a total for each day. I would like to include a weekly total to be displayed on Fridays only, for each particular week. Furthermore, I would like to display the weekly total on Thursdays when Friday is not a workday. Is there a way to use a subtotal that will recognize a new or different workweek and perform this calculation? If not, any thoughts on how to do this using a macro? I also need to be able to provide a monthly and yearly total as well. Thanks for any help you may have! |
All times are GMT +1. The time now is 12:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com