I have a pivot table with 5 columns. There is a calendar selector object. Whatever day is selected is used for the first column's calculations. The next column uses the selected day minus one and so on. My problem is that I want to exclude weekends. So if 1/25/2011 is selected (which is a Tuesday) the columns will show values based off of the following dates:
Before i just had a variable that equaled the selected date vDailyDate, then I did (vDailyDate-1) ... (vDailyDate -2) ... and so on for the previous days but this obviously doesn't work for excluding weekends.