Get the date of saturday in a week from a week number / year

**JasperD** · 03-18-2015, 07:37 AM

Hi guys,

i get a weeknumber and a year number as input from a user.
I'd like to get the date of the Saturday in that week.

For example, week 11/2015 (last week), the date of the saturday would be 3/14
How do I go about that in vba?
Let's say I have variables
wk = 11
and
yr = 2015

How do I translate that to 03/14/2015 ?

Thanks,

Jasper

**Richard Buttrey** · 03-18-2015, 07:59 AM

Hi,

Do you really need VBA for this.

With 2015 in A1 and 11 in A2 then

Formula:

Please Login or Register  to view this content.

If you need to use it in VBA then just read the formula cell into VBA

**JOHN H. DAVIS** · 03-18-2015, 08:30 AM

Does this help?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Note: uses A2 as helper cell.

**daddylonglegs** · 03-18-2015, 06:56 PM

Originally Posted by Richard Buttrey

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

This finds the 11th Saturday in 2015 for the example given but this depends on how your week numbers work - in the Netherlands I imagine these might be ISO week numbers, in which case the first Saturday of the year might be in the last week of the previous year, e.g. ISO week number 1 for 2016 begins on 4th January 2016. The previous Saturday (2nd Jan) is in week 53 of 2015

Given the above this formula should give you the correct Saturday date (assuming ISO week numbers) in any year

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