VBA Program that returns the first monday of a month

[Taoyuan00]

Dear Friends

I am trying to write a VBA code that allows me to enter a month and year in cells A2 and B2 respectively. After that it displays in C2 the date of the first Monday of that month in the inputted year. As an example, say I write October in A2 and 2016 in B2, it should return in C2: 3/10/2016. May someone help me please.

Thank you code pros!

Taoyuan00

[buran]

Assuming you have the month in A1 and the year in B1 you can use formula like this in C1

Please Login or Register  to view this content.

[Taoyuan00]

Thanks a span Buran. It is certainly a good one. This only works when you use the month number though. If the month is in words it won't work. I am wondering if I can formulate code that uses If statements in VBA so that even if the month is spelt in words it will still give me the first Monday.

[buran]

that wasn't mentioned in your question

Please Login or Register  to view this content.

[Taoyuan00]

Thank you very much Buran. You are great!!!