I prefer to do it with code. Is there also an Excel function that does this
I am unaware of?

"Mike" wrote:

You can do this with formula or code. Which one is
necessary for your application?
-----Original 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.
.