Thanks for the quick response, that formula is bringing up yesterdays
date but when I change my PC clock to a Monday it still brings up
yesterdays date (as in the 27th not Sunday 30th).

Can you explain the formula step by step so I can understand what it's
trying to achieve?

Thanks again for your help, it's much appreciated!

Max wrote:
Try:
=IF(WEEKDAY(TODAY(),2)=1,TODAY()-3,TODAY()-1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
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!