Hi - Dave here.
Here's a tricky problem for you....
How can you sum values by day of week like the worksheet below?
[
download the workbook and read the full explanation]
Believe it or not, you can solve this problem nicely with the TEXT function :) Using the TEXT function this way is one of my favorite tricks for certain date problems. The link above includes the workbook and a detailed explanation. Have a look and try it out for yourself.
Excel formulas
We maintain a large list of working formulas
here.
If you need more structure, we also offer
video training.
Have a nice weekend!
Dave
