Thread: Get date from WEEK No.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Get date from WEEK No.
Your welcome

"Francois via OfficeKB.com" wrote:

Mike H wrote:
Hi,

Week number in A1 and a year in a2

=DATE(A2,1,1)+((A1-1)*7)-WEEKDAY(DATE(A2,1,1)+(A1-1)*7,2)+1

Mike

Hi ,

[quoted text clipped - 5 lines]

Thanks




Excellent, Thanks a lot

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200909/1


Reply With QuoteReply With Quote