Finding Friday in week number
=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
|