I need help tracking the last 30 days, but also excluding weekends. In cell A1 I currently have the formula =Today()-30 so that everyday it will automatically change to 30 days ago. In cell A2 I have =A1+1, in cell A3 I have =A2+1, and this goes on until Cell A30. The problem I run into is that by doing this it will include weekend dates which I do not need. The data from this is charted, and if the weekends are included then it will show 0 on the chart, and affect the true trendline. Any help with this would be appreciated.