how to exclude week end without use networkday

[Fred12]

Hello, I want to have date from yesterday. 

For exemple, today I did in my script :

where date_creation = today()-1   

But yesterday, we were sunday, I would like to recover the date_creation of fryday then.

Thx in advance

[Or]

=FirstWorkDate(Today()-1,1) should do the trick here, I believe.