<the first Monday of the Year required
Which is:
=DATE(Yr,1,1+(Nth-(Dow=WEEKDAY(DATE(Yr,1,1))))*7)+ Dow-WEEKDAY(DATE(Yr,1,1))
Where Dow = 2.
From Chip Pearson:
http://www.cpearson.com/excel/DateTi...tm#LastWeekday
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Roger Govier" wrote in message ...
| Hi
|
| With A1 holding the first Monday of the Year required e.g 02 Jan 2006
| and A2 holding the week number then
| =A1+(A2-1)*7
|
| --
| Regards
|
| Roger Govier
|
|
| "TheRook" wrote in message
| ...
| Is there a formula to find a specific date from a week no?
|
| For example Week 42 day 2 (Monday) would result 16/10/06
|
| Regards
|
|