Thread: Finding a specific date from a week no.
View Single Post
  #3   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.
correction, pasted the wrong one

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


Reply With QuoteReply With Quote