I am working with a spreadsheet that has detailed history of various
financial transactions occuring during a workweek only. Column A is the date
in day form ('Wednesday', etc.), Column B is the date in date form
('3/7/06'), and Columns C through F are various types of expenses. Column G
gives a total of C through F for each day. Okay, that's all well and good. My
problem is with Column H in which I would like to show a weekly total of
everything from Monday through Friday, and on weeks when Friday is not a
workday, Monday through Thursday. I'd like this to only display on Fridays or
Thursdays. Is there a way to do a subtotal that will recognize a different
workweek and display a total? For that matter, a different month and year,
too? Thanks!