I need to make TODAY() only inlcude weekdays never weekends. I need to set
up a formula that will show yesterday's date, but I don't want it to ever
give me the weekend. I am only interested in weekdays... Any suggestions?
+TODAY()-1 gives me yesterady but will return the weekend, I don't want to
have to say =TODAY()-3, because it's only minus 3 on Friday...