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!