calculate weekdays only
 

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.
.

calculate weekdays only
 

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.
.

calculate weekdays only
 

dtDate = Range(A1)-1-choose(Weekday(Range(A1).Value)-1,2,0,0,0,0,0,1)

--
Regards,
Tom Ogilvy


"benb" wrote in message
...
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.
.