Can anyone help me put yesterday's date on an Excel Spreadsheet please ?
When I say yesterday's date, I only want to count Weekdays.
So for example, if I do it on a Tuesday, the formula =TODAY()-1 will give me the correct date.
However, if I do the same on a Monday, the formula will be incorrect because it will give me Sunday's date.
In this instance I would want the previous Friday's date.
Thanks in advance.