Finding Friday in week number

  • Thread starter Thread starter DavidS
  • Start date Start date
D

DavidS

Hello, I have a week number and am trying to find the date of the Friday in
that week. The week number is selected in a drop down and used elsewhere so
I can't change it but need to derive the date of the Friday in the selected
week number. Can't find a way of doing this with my limited knowledge.
Thanks for looking.
David
 
I found that the easiest way for me to do this quickly was to determine the
date of the Friday in the first week. Assumes week starts on Sunday. First
friday can potentially be in previous year if you are starting with Jan 1 as
1st day entered.

But, works great for 2006 where 1/1/2006 was a Sunday.

Determine the date for the first Friday, i.e. 1/6/2006 for 2006
Assume that date is in G2 and you enter the weeknumber you want in G1
Then this formula will calculate date of Friday in a weeknumber:
=G$2+((G1-1)*7)
If G1 = 1, date is 1/6/2006
G1 = 8, 2/24/2006
G1 -50, 12/15/2006
 
=TODAY()+6-MOD(TODAY(),7)+(your_weeknum-WEEKNUM(TODAY()))*7

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
Much better solution! I'm saving that one.

Bob Phillips said:
=TODAY()+6-MOD(TODAY(),7)+(your_weeknum-WEEKNUM(TODAY()))*7

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
Click to expand...
 
Forgot to mention that this solution does assume that you are using the MS
definition of a week number. Post back if you want an ISO defined week
number solution.

--
HTH

Bob Phillips

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