View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mike mike is offline
external usenet poster
 
Posts: 216
Default 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.
.