Counting Dates in weeks per Month

[Walker_Ice]

Hi everyone,

Is there a way to check what days of the week my dates in my dates column fall under? And is there a way to check what week of the month that falls under as well?
Below is an example what I am trying to do. As you can see in the table below. I have my data set up and I have 2 mini tables representing what I am trying to accomplish. Can someone help me with this?

Thank you in advanced.

TEsting_Excel_File.xlsx
	A	B	C	D	E	F
1	Income Services				Week #	Per Month
2	Service	Date	Payment		1st Week	10
3	MDL	4-Feb-21	$900.00		2nd Week	5
4	LDL	13-Mar-23	$300.00		3rd Week	90
5	POL	17-Jun-22	$200.00		4th Week	35
6	POW	7-Jun-23	$900.00		5th Week	3
7	MAN	10-Jul-23	$1,900.00
8	INO	31-Mar-24	$23.00
9	YOU	26-May-23	$875.00
10	TBW	18-Feb-23	$750.00		WeekDay	Services per WeekDay
11	DPW	1-Jun-23	$600.00		Monday	39
12	MDL	18-Feb-24	$600.00		Tuesday	22
13	RDL	18-Mar-23	$850.00		Wednesday	16
14	NAM	28-May-22	$850.00		Thursday	16
15	PPP	8-Feb-23	$10,000.00		Friday	15
16	PPE	3-Mar-23	$100.00		Saturday	15
17	PPE	4-Jan-21	$100.00		Sunday	13
18	INO	14-Feb-23	$23.00
19	LDL	1-Apr-23	$300.00
20	HDL	3-Jan-22	$8,500.00
21	AND	25-Feb-23	$20,000.00
22	WWW	26-Jun-25	$700.00
23	WDL	10-Mar-23	$899.00
Sheet5

 

[Peter_SSs]

Duplicate to: Week of the Month Popularity

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.