Hey all, so here's what I need to do...
I need the cell to display the previous weekday's date. For example, if today is Tuesday the 19th, the cell with read "11/18/2013". But if it's on next Monday the 25th for example, it will show that previous Friday's date "11/22/2013".

I feel like this is probably pretty simple, but am still having a bit of trouble figuring it out. Thanks for your understanding!