Thread: Get date from WEEK No.
View Single Post
  #2   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.
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

"Francois via OfficeKB.com" wrote:

Hi ,

I am using a Formula from Chip Pearson that will give the WEEK No. (ISO) for
an entered date.

Is there a way to enter a WEEK No. (and year) and get the date of the Monday
in that Week


Thanks

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


Reply With QuoteReply With Quote