You could use WEEKDAY as an input to an IF function, or use the WORKDAY
function. You'll find the relevant functions in Excel help.
--
David Biddulph

wrote in message
oups.com...
I have a daily report that I am in the process of automating. The
report needs to date sales from the day before, excluding the weekend.

E.g. today is Friday 28th, the report is run for Thurs 27th. I can do
this using the =TODAY()-1 function but this comes unstuck on Mondays,
as the report then lists Sundays date and I need it to list Fridays
instead.

Does anyone know of a way to do this??

Cheers!