Get date from WEEK No.

[Francois via OfficeKB.com]

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

 

[Mike H]

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]

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

 

[Mike H]

Your welcome

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