Get date from WEEK No.
 

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

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

Get date from WEEK No.
 

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

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