Date formats in VB question

[KillGorack]

I have a week number (ISO), and a year. I need to get a date in mm/dd/yyyy on the Monday

for example a system we use provides this;
202308

And would love a bit of code to turn that into
02/20/2023

Not in a cell but with VB code

I'm wracking my brain...

 

[KillGorack]

One small change:

Function jec(cell As Variant, day As Integer) As Long
jec = 7 * (Right(cell, 2) - 1) + DateSerial(Left(cell, 4), 1, 4) - Weekday(DateSerial(Left(cell, 4), 1, 4), 2) + day
End Function

=jec(A1,1)

As I understand it'll come back with whatever weekday needed, yes?

 

[JEC]

Yes, so if you write = jec(A1,5) , it gives you the date of Friday