In Microsoft Excel, I would like to subtract Saturday, Sunday, & Monday from the days of the week and still have the formula give me a calculated day. Right now I have a WEEKDAY formula that calculates 29 days subtracted from a final date (i.e. January 22, 2010 - 29 --> final answer Dec 15, 2009) but excluding weekends (Sat & Sun) & Mon...I'm not sure how to utilize that formula or one similar to also subtract Mondays.
I'm using Excel 2007.
I'm using Excel 2007.