In column B, I have dates. I need to figure out what the first working day in that week was, and populate that date in another column.
For e.g., if I had 1/13/11 in B2, then in C2, I want the date 1/10/11.
I am trying to figure out how many events I had each week. My thought is to do a pivot...