Thank-you.

Bob

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
Much better solution! I'm saving that one.

"Bob Phillips" wrote:

=TODAY()+6-MOD(TODAY(),7)+(your_weeknum-WEEKNUM(TODAY()))*7

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

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