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
|