Identify Week from a date

[Ashti]

Given a date for ex:01/07/2020, is there any way to identify whether it belongs to 1st week of July or sec week?

 

[Joe4]

Assuming that the dates you are working on will always be the first or second week, you could use a formula like this (for a date in cell A1):
=IF(DAY(A1)<WEEKDAY(A1),1,2)

 

[Ashti]

Given the date as an input as shown below, I would like the output to be as described in the week column. I would that for all months in the year.

Date	Week
01/07/2020​	Week1_July
02/07/2020​	Week1_July
03/07/2020​	Week2_July
06/07/2020​	Week2_July
07/07/2020​	Week2_July
08/07/2020​	Week2_July
09/07/2020​	Week2_July
10/07/2020​	Week2_July
13/07/2020​	Week3_July
14/07/2020​	Week3_July

 

[gaz_chops]

Your weeks don't appear to make sense! 2/7/20 = end of wk1, next week ends on 10/11/12th July!

 

[Fluff]

Maybe

+Fluff New.xlsm
	A	B
1
2	01/07/2020	1
3	02/07/2020	1
4	03/07/2020	1
5	04/07/2020	2
6	05/07/2020	2
7	06/07/2020	2
8	07/07/2020	2
9	08/07/2020	2
10	09/07/2020	2
11	10/07/2020	2
12	11/07/2020	3
13	12/07/2020	3
14	13/07/2020	3
15	14/07/2020	3
16	15/07/2020	3
17	16/07/2020	3
18	17/07/2020	3
19	18/07/2020	4
20	19/07/2020	4
Main

Cell Formulas
Range	Formula
B2:B20	B2	=WEEKNUM(A2,16)-WEEKNUM(EOMONTH(A2,-1)+1,16)+1

This assumes that Saturday is the first day of each week. Your sample data is contradictory.

 

[Ashti]

What do I have to change if Monday is the start/first day of the week

 

[Fluff]

Change both 16s to 2