View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default calculate weekdays only

=A1-1-choose(Weekday(A1)-1,2,0,0,0,0,0,1)

--
Regards,
Tom Ogilvy



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