Return the Thursday Date before an Input Date Q

  • Thread starter Thread starter John
  • Start date Start date
J

John

I am looking to return a date in Column B that is the Thursday before the
date in Column A. For example

A1 = 23/6/04
Thus B1 should = 17/6/04

It seems very easy, but I can't just use A1-4 because the date in A1 might
be anything (of 7 days) going forward

Thanks
 
Hi John!

One way:
=A1-CHOOSE(WEEKDAY(A1,2),4,5,6,0,1,2,3)

It returns the same day if A1 is a Thursday
 
If perchance you want the previous Thursday if it is a Thursday, use

=A1-CHOOSE(WEEKDAY(A1,2),4,5,6,7,1,2,3)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
John,

=A1-WEEKDAY(A1+2)


--
Regards,
Soo Cheon Jheong
Seoul, Korea
_ _
^¢¯^
--
 
That returns Saturdays not Thursdays.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Bob,

That returns Saturdays not Thursdays.
Click to expand...

???

You lucky guy : always having very long week-ends. :-)

Perhaps you really had one too long, tough <bg>

Regards,

Daniel M.
 
Don't know what I tried as I have scrubbed it now, but you are right.
Apologies to Soo Cheon Jheong.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Bob,

That returns Thursdays not Saturdays for me (ExcelXP; Korean Version)


--
Regards,
Soo Cheon Jheong
Seoul, Korea
_ _
^¢¯^
 
Yes, it was my mistake, and I have already acknowledged it (see the thread).
No idea what I did, but I must have mis-tarnscribed it.

Bob
 
Back
Top