View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
benb benb is offline
external usenet poster
 
Posts: 18
Default calculate weekdays only

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.