Vlookup or VBA to get correct week No for Month

[nironto]

Hi All,
Need some help here.

I have on Sheet1 Column A the Financial Month. In a month, there are 4 or 5 weeks and I want to get the start day of every week (Monday) as seen in sheet2
Instead I managed only to get the last week day that applies all weeks of the month. (instead of every week)

Is there a way to get the desired output via formula or script?

Regards,
Nironto

[Fotis1991]

Hi

1 way using formulas could be this.

Create a helper and hidden column using this formula.

=IF(B4=B3;A3+1;1)

Then use this ARRAY formula.

=INDEX(Sheet2!$C$2:$C$1000;MATCH(A3&B3;Sheet2!$B$2:$B$1000&Sheet2!$A$2:$A$1000;0))

-- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
Not just Enter.

[nironto]

Thanks Fotis1991 as always! u rock!

[Fotis1991]

........................