=A1-1-choose(Weekday(A1)-1,2,0,0,0,0,0,1)

--
Regards,
Tom Ogilvy



"benb" wrote in message
...
I am looking for code to insert yesterday's date if yesterday was a
weekday,
and to use the previous Friday's date otherwise (if yesterday was Sunday).
Anyone know how to do this? Thanks.