return date as today minus one or minus 3 if Monday

As it is Friday I am now brain dead. Can an expert out there provide me the formula to return date as today minus one or minus 3 if Monday

Thanks
JagwarmanAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

pls try

=WorkDay(today(),-1)

Open in new window

Regards
0
 
NBVCConnect With a Mentor Commented:
Try:

=WORKDAY(TODAY(),-1)
0
All Courses

From novice to tech pro — start learning today.