I have an excel sheet header which includes a date, the date is to represent yesterday's date ( =Today()-1 ), which then would come into the spread sheet as August 8th, 2005, assuming today was August 9th. The problem is on days like Monday when the previous day was sunday, how can I make the formula output the Friday before the Monday instead of Sunday ...example on Monday, August 11th, the formula would read August 10th, I need it to read August 8th...? Please help, thanks
Bookmarks