Thread: Change to formula to make it go to next weekday (i.e., avoid weekend days)?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
StargateFan[_2_] StargateFan[_2_] is offline
external usenet poster
  
Posts: 12
Default Change to formula to make it go to next weekday (i.e., avoid weekend days)?
I have a very specific formula that I need to keep the same. However,
I need to make the output come out as a weekday at all times. How can
I do this pls?

=CHOOSE(WEEKDAY(TODAY()+1),"Sn","Mn","Tu","Wd","Th ","Fr","Sa") &
TEXT(TODAY()+1,"\.mmm.dd.yyyy")

Thanks so much!! :oD
Reply With QuoteReply With Quote