Week Name Based on Month

[kumara_faith]

Hi,

I have the following table:

Date	Week
3/1/2022​	Jan Week 1
12/1/2022​	Jan Week 2
5/2/2022​	Feb Week 1
4/3/2022​	Mar Week 1

I have the dates in the first column. In the second column, I am trying to name the week based on the date. For example 3/1/2022 is Jan Week 1.

Is it possible to do this with a formula ? Appreciate all the help.

 

[BSALV]

difficult discussion similar to the iso weeknumbers, what's the first week in a month ?
- the first monday is the start of week 1 of that month
- you cut the week in to parts, and week 1 start at the 1st of that month
- you do ISO and the major part of the week (check the thursday) determines the weeknumber.

 

[kumara_faith]

Hi,

If the date falls within Mon- Sunday, we can take it as the first week and similar to subsequent weeks.

Is this possible ?

 

[BSALV]

so the first day of your weeks is the monday and if the 1st of the month is a sun or mon then that one is week 1, otherwise 1 week later.
The boys/girls, with a better knowlegde for LET-functions, can do this within a second.

 

[kumara_faith]

Hi,

How do we use LET function for this ?

 

[fhqwgads]

is monday 28/02/2022 march week 1 or feb week 4?

 

[kumara_faith]

Hi,
We can categorize that as week 4 for Feb.

 

[kumara_faith]

My apologies. As long as the day is going into the next circle of Monday to Sunday, can we categorize it as the following week ? In this case we categorize it as week 5?

 

[fhqwgads]

right sorry that would be week 5, i miscounted the weeks in feb when i asked

 

[fhqwgads]

just further clarification
friday 31/12/2021 would be dec week 5
saturday 01/01/2022 would be jan week 1
monday 03/01/2022 would be jan week 2
monday 31/01/2022 would be jan week 6?