First Monday in the Year

[Thifiell]

Hello

I have seen a topic like that already here, but my question is a bit different. I don't have any column with all dates, I have a sheet where I must write a logistic plan which goes by days of the week.
For instance 2 transports on Monday, 4 on Tuesday, 2 on Wednesday and 5 on Friday.

and this is for week 6 (February). I need to do it for all others weeks, this year and for next 10 years for example. I would like to write it so I can just copy paste formulas, so I would like to have for January first Monday, first Monday, after first Tuesday 4x and so on. I am sure that all dates in Excel are somehow recorded and we can recall them. Do you have any idea how to write it so I can just copy/paste for next months and years?

 

[jasonb75]

The comma / semi-colon thing does cause unnecessary confusion at times. It is actually tied to how you write numbers normally, in countries that use a comma for a decimal separator, the formulas will need semi-colons, for countries that use the dot / period / decimal point as a decimal separator, the comma is used for the formula.

Decimal separator - Wikipedia

en.wikipedia.org

I still don't understand what should show B column? What is 43500? The logic is well though, I see 2x 43500 for Monday and 4 of 43501 for Tuesday, like it should be

Those numbers are date serial numbers, change the format to date and you will see the correct dates in column B
From the office support site

Excel stores dates as sequential serial numbers so that they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,447 days after January 1, 1900.

Try the formulas with column B formatted as date, then start it with 2020 and week 1. See if it is close to what you have for your manually created sheet.