View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
moon[_7_] moon[_7_] is offline
external usenet poster
 
Posts: 53
Default Finding a specific date from a week no.


"TheRook" schreef in bericht
...
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



Put weeknumber 42 in Cel A2 and daynumber 2 in Cel B2, then try this one.

=DATE(2006;12;31)-(365-(((365/52)*A2)-(IF((7-B2)0;7-B2;B2-7))))

Not sure, I only tested 10/16/06, 01/01/01 and 12/31/06 with a positive
result.