Thread: Find the previous Weekday (thursday)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
  
Posts: 10,593
Default Find the previous Weekday (thursday)
=A1+CHOOSE(WEEKDAY(A1),-3,-4,-5,-6,0,-1,-2)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"JimDandy" wrote in
message ...

How can I identify the previous Thursday given a date? For instance, if
I have a date (08/08/2006) in cell A4 and I need to know what the date
is for the previous Thursday (08/03/2006), what formula could identify
that date?


--
JimDandy
------------------------------------------------------------------------
JimDandy's Profile:
http://www.excelforum.com/member.php...o&userid=16578
View this thread: http://www.excelforum.com/showthread...hreadid=570418



Reply With QuoteReply With Quote