Friday of a given week
 

Give this formula a try...

="1/1/2009"+7*A1-WEEKDAY("1/1/2009"+7*A1-6)

Changing the A1 reference to the address of the first cell with a week
number in it.

--
Rick (MVP - Excel)


"QB" wrote in message
...
I have a row with week numbers and would like to insert a row above it
which
list the Friday of that week number. How can I do this?

Week 19 would give 2009-May-08 (yyyy-mmm-dd)

Thank you

QB