DEFINE MONTH BASE ON CERTAIN DATES (EXCEL)

[mohdamir1989]

Hi All,

I have little to no knowledge about the below scenario I just received.

We do billing cycle from 21st to 20 of each month. I have data of 2 years which contains more than 1 lac entries.

I want to name the closing month in last of data.

Closing date 12/21/2022 (mm,dd,yyyy).

What I am trying to achieve is to define 21st Dec 2022 to 20th Jan 2023 as January 2023


Your kind support is highly appreciated

Thanking in anticipation

 

[awoohaw]

Try this:

Book1
	A	B
1	Transaction Date	Statement Month
2	2022-01-01	January 2022
3	2022-01-02	January 2022
4	2022-01-03	January 2022
5	2022-01-04	January 2022
6	2022-01-05	January 2022
7	2022-01-06	January 2022
8	2022-01-07	January 2022
9	2022-01-08	January 2022
10	2022-01-09	January 2022
11	2022-01-10	January 2022
12	2022-01-11	January 2022
13	2022-01-12	January 2022
14	2022-01-13	January 2022
15	2022-01-14	January 2022
16	2022-01-15	January 2022
17	2022-01-16	January 2022
18	2022-01-17	January 2022
19	2022-01-18	January 2022
20	2022-01-19	January 2022
21	2022-01-20	January 2022
22	2022-01-21	February 2022
23	2022-01-22	February 2022
24	2022-01-23	February 2022
25	2022-01-24	February 2022
26	2022-01-25	February 2022
27	2022-01-26	February 2022
28	2022-01-27	February 2022
29	2022-01-28	February 2022
30	2022-01-29	February 2022
31	2022-01-30	February 2022
32	2022-01-31	February 2022
33	2022-02-01	February 2022
34	2022-02-02	February 2022
35	2022-02-03	February 2022
36	2022-02-04	February 2022
37	2022-02-05	February 2022
38	2022-02-06	February 2022
39	2022-02-07	February 2022
40	2022-02-08	February 2022
41	2022-02-09	February 2022
42	2022-02-10	February 2022
43	2022-02-11	February 2022
44	2022-02-12	February 2022
45	2022-02-13	February 2022
46	2022-02-14	February 2022
47	2022-02-15	February 2022
48	2022-02-16	February 2022
49	2022-02-17	February 2022
50	2022-02-18	February 2022
51	2022-02-19	February 2022
52	2022-02-20	February 2022
53	2022-02-21	March 2022
54	2022-02-22	March 2022
55	2022-02-23	March 2022
56	2022-02-24	March 2022
57	2022-02-25	March 2022
58	2022-02-26	March 2022
59	2022-02-27	March 2022
60	2022-02-28	March 2022
61	2022-03-01	March 2022
62	2022-03-02	March 2022
63	2022-03-03	March 2022
64	2022-03-04	March 2022
65	2022-03-05	March 2022
66	2022-03-06	March 2022
67	2022-03-07	March 2022
68	2022-03-08	March 2022
69	2022-03-09	March 2022
70	2022-03-10	March 2022
71	2022-03-11	March 2022
72	2022-03-12	March 2022
73	2022-03-13	March 2022
74	2022-03-14	March 2022
75	2022-03-15	March 2022
76	2022-03-16	March 2022
77	2022-03-17	March 2022
78	2022-03-18	March 2022
79	2022-03-19	March 2022
80	2022-03-20	March 2022
81	2022-03-21	April 2022
82	2022-03-22	April 2022
83	2022-03-23	April 2022
84	2022-03-24	April 2022
85	2022-03-25	April 2022
86	2022-03-26	April 2022
87	2022-03-27	April 2022
88	2022-03-28	April 2022
89	2022-03-29	April 2022
90	2022-03-30	April 2022
91	2022-03-31	April 2022
92	2022-04-01	April 2022
93	2022-04-02	April 2022
94	2022-04-03	April 2022
95	2022-04-04	April 2022
96	2022-04-05	April 2022
97	2022-04-06	April 2022
98	2022-04-07	April 2022
99	2022-04-08	April 2022
100	2022-04-09	April 2022
101	2022-04-10	April 2022
102	2022-04-11	April 2022
103	2022-04-12	April 2022
104	2022-04-13	April 2022
105	2022-04-14	April 2022
106	2022-04-15	April 2022
107	2022-04-16	April 2022
108	2022-04-17	April 2022
109	2022-04-18	April 2022
110	2022-04-19	April 2022
111	2022-04-20	April 2022
112	2022-04-21	May 2022
113	2022-04-22	May 2022
114	2022-04-23	May 2022
115	2022-04-24	May 2022
116	2022-04-25	May 2022
117	2022-04-26	May 2022
118	2022-04-27	May 2022
119	2022-04-28	May 2022
120	2022-04-29	May 2022
121	2022-04-30	May 2022
122	2022-05-01	May 2022
123	2022-05-02	May 2022
124	2022-05-03	May 2022
125	2022-05-04	May 2022
126	2022-05-05	May 2022
127	2022-05-06	May 2022
128	2022-05-07	May 2022
129	2022-05-08	May 2022
130	2022-05-09	May 2022
131	2022-05-10	May 2022
132	2022-05-11	May 2022
133	2022-05-12	May 2022
134	2022-05-13	May 2022
135	2022-05-14	May 2022
136	2022-05-15	May 2022
137	2022-05-16	May 2022
138	2022-05-17	May 2022
139	2022-05-18	May 2022
140	2022-05-19	May 2022
141	2022-05-20	May 2022
142	2022-05-21	June 2022
143	2022-05-22	June 2022
144	2022-05-23	June 2022
145	2022-05-24	June 2022
146	2022-05-25	June 2022
147	2022-05-26	June 2022
148	2022-05-27	June 2022
149	2022-05-28	June 2022
150	2022-05-29	June 2022
151	2022-05-30	June 2022
152	2022-05-31	June 2022
153	2022-06-01	June 2022
154	2022-06-02	June 2022
155	2022-06-03	June 2022
156	2022-06-04	June 2022
157	2022-06-05	June 2022
158	2022-06-06	June 2022
159	2022-06-07	June 2022
160	2022-06-08	June 2022
161	2022-06-09	June 2022
162	2022-06-10	June 2022
163	2022-06-11	June 2022
164	2022-06-12	June 2022
165	2022-06-13	June 2022
166	2022-06-14	June 2022
167	2022-06-15	June 2022
168	2022-06-16	June 2022
169	2022-06-17	June 2022
170	2022-06-18	June 2022
171	2022-06-19	June 2022
172	2022-06-20	June 2022
173	2022-06-21	July 2022
174	2022-06-22	July 2022
175	2022-06-23	July 2022
176	2022-06-24	July 2022
177	2022-06-25	July 2022
178	2022-06-26	July 2022
179	2022-06-27	July 2022
180	2022-06-28	July 2022
181	2022-06-29	July 2022
182	2022-06-30	July 2022
183	2022-07-01	July 2022
184	2022-07-02	July 2022
185	2022-07-03	July 2022
186	2022-07-04	July 2022
187	2022-07-05	July 2022
188	2022-07-06	July 2022
189	2022-07-07	July 2022
190	2022-07-08	July 2022
191	2022-07-09	July 2022
192	2022-07-10	July 2022
193	2022-07-11	July 2022
194	2022-07-12	July 2022
195	2022-07-13	July 2022
196	2022-07-14	July 2022
197	2022-07-15	July 2022
198	2022-07-16	July 2022
199	2022-07-17	July 2022
200	2022-07-18	July 2022
201	2022-07-19	July 2022
202	2022-07-20	July 2022
203	2022-07-21	August 2022
204	2022-07-22	August 2022
205	2022-07-23	August 2022
206	2022-07-24	August 2022
207	2022-07-25	August 2022
208	2022-07-26	August 2022
209	2022-07-27	August 2022
210	2022-07-28	August 2022
211	2022-07-29	August 2022
212	2022-07-30	August 2022
213	2022-07-31	August 2022
214	2022-08-01	August 2022
215	2022-08-02	August 2022
216	2022-08-03	August 2022
217	2022-08-04	August 2022
218	2022-08-05	August 2022
219	2022-08-06	August 2022
220	2022-08-07	August 2022
221	2022-08-08	August 2022
222	2022-08-09	August 2022
223	2022-08-10	August 2022
224	2022-08-11	August 2022
225	2022-08-12	August 2022
226	2022-08-13	August 2022
227	2022-08-14	August 2022
228	2022-08-15	August 2022
229	2022-08-16	August 2022
230	2022-08-17	August 2022
231	2022-08-18	August 2022
232	2022-08-19	August 2022
233	2022-08-20	August 2022
234	2022-08-21	September 2022
235	2022-08-22	September 2022
236	2022-08-23	September 2022
237	2022-08-24	September 2022
238	2022-08-25	September 2022
239	2022-08-26	September 2022
240	2022-08-27	September 2022
241	2022-08-28	September 2022
242	2022-08-29	September 2022
243	2022-08-30	September 2022
244	2022-08-31	September 2022
245	2022-09-01	September 2022
246	2022-09-02	September 2022
247	2022-09-03	September 2022
248	2022-09-04	September 2022
249	2022-09-05	September 2022
250	2022-09-06	September 2022
251	2022-09-07	September 2022
252	2022-09-08	September 2022
253	2022-09-09	September 2022
254	2022-09-10	September 2022
255	2022-09-11	September 2022
256	2022-09-12	September 2022
257	2022-09-13	September 2022
258	2022-09-14	September 2022
259	2022-09-15	September 2022
260	2022-09-16	September 2022
261	2022-09-17	September 2022
262	2022-09-18	September 2022
263	2022-09-19	September 2022
264	2022-09-20	September 2022
265	2022-09-21	October 2022
266	2022-09-22	October 2022
267	2022-09-23	October 2022
268	2022-09-24	October 2022
269	2022-09-25	October 2022
270	2022-09-26	October 2022
271	2022-09-27	October 2022
272	2022-09-28	October 2022
273	2022-09-29	October 2022
274	2022-09-30	October 2022
275	2022-10-01	October 2022
276	2022-10-02	October 2022
277	2022-10-03	October 2022
278	2022-10-04	October 2022
279	2022-10-05	October 2022
280	2022-10-06	October 2022
281	2022-10-07	October 2022
282	2022-10-08	October 2022
283	2022-10-09	October 2022
284	2022-10-10	October 2022
285	2022-10-11	October 2022
286	2022-10-12	October 2022
287	2022-10-13	October 2022
288	2022-10-14	October 2022
289	2022-10-15	October 2022
290	2022-10-16	October 2022
291	2022-10-17	October 2022
292	2022-10-18	October 2022
293	2022-10-19	October 2022
294	2022-10-20	October 2022
295	2022-10-21	November 2022
296	2022-10-22	November 2022
297	2022-10-23	November 2022
298	2022-10-24	November 2022
299	2022-10-25	November 2022
300	2022-10-26	November 2022
301	2022-10-27	November 2022
302	2022-10-28	November 2022
303	2022-10-29	November 2022
304	2022-10-30	November 2022
305	2022-10-31	November 2022
306	2022-11-01	November 2022
307	2022-11-02	November 2022
308	2022-11-03	November 2022
309	2022-11-04	November 2022
310	2022-11-05	November 2022
311	2022-11-06	November 2022
312	2022-11-07	November 2022
313	2022-11-08	November 2022
314	2022-11-09	November 2022
315	2022-11-10	November 2022
316	2022-11-11	November 2022
317	2022-11-12	November 2022
318	2022-11-13	November 2022
319	2022-11-14	November 2022
320	2022-11-15	November 2022
321	2022-11-16	November 2022
322	2022-11-17	November 2022
323	2022-11-18	November 2022
324	2022-11-19	November 2022
325	2022-11-20	November 2022
326	2022-11-21	December 2022
327	2022-11-22	December 2022
328	2022-11-23	December 2022
329	2022-11-24	December 2022
330	2022-11-25	December 2022
331	2022-11-26	December 2022
332	2022-11-27	December 2022
333	2022-11-28	December 2022
334	2022-11-29	December 2022
335	2022-11-30	December 2022
336	2022-12-01	December 2022
337	2022-12-02	December 2022
338	2022-12-03	December 2022
339	2022-12-04	December 2022
340	2022-12-05	December 2022
341	2022-12-06	December 2022
342	2022-12-07	December 2022
343	2022-12-08	December 2022
344	2022-12-09	December 2022
345	2022-12-10	December 2022
346	2022-12-11	December 2022
347	2022-12-12	December 2022
348	2022-12-13	December 2022
349	2022-12-14	December 2022
350	2022-12-15	December 2022
351	2022-12-16	December 2022
352	2022-12-17	December 2022
353	2022-12-18	December 2022
354	2022-12-19	December 2022
355	2022-12-20	December 2022
356	2022-12-21	January 2023
357	2022-12-22	January 2023
358	2022-12-23	January 2023
359	2022-12-24	January 2023
360	2022-12-25	January 2023
361	2022-12-26	January 2023
362	2022-12-27	January 2023
363	2022-12-28	January 2023
364	2022-12-29	January 2023
365	2022-12-30	January 2023
366	2022-12-31	January 2023
367	2023-01-01	January 2023
Sheet1

Cell Formulas
Range	Formula
B2:B367	B2	=EOMONTH(A2,--(DAY(A2)>=21))

 

[mohdamir1989]

Try this:

Book1
	A	B
1	Transaction Date	Statement Month
2	2022-01-01	January 2022
3	2022-01-02	January 2022
4	2022-01-03	January 2022
5	2022-01-04	January 2022
6	2022-01-05	January 2022
7	2022-01-06	January 2022
8	2022-01-07	January 2022
9	2022-01-08	January 2022
10	2022-01-09	January 2022
11	2022-01-10	January 2022
12	2022-01-11	January 2022
13	2022-01-12	January 2022
14	2022-01-13	January 2022
15	2022-01-14	January 2022
16	2022-01-15	January 2022
17	2022-01-16	January 2022
18	2022-01-17	January 2022
19	2022-01-18	January 2022
20	2022-01-19	January 2022
21	2022-01-20	January 2022
22	2022-01-21	February 2022
23	2022-01-22	February 2022
24	2022-01-23	February 2022
25	2022-01-24	February 2022
26	2022-01-25	February 2022
27	2022-01-26	February 2022
28	2022-01-27	February 2022
29	2022-01-28	February 2022
30	2022-01-29	February 2022
31	2022-01-30	February 2022
32	2022-01-31	February 2022
33	2022-02-01	February 2022
34	2022-02-02	February 2022
35	2022-02-03	February 2022
36	2022-02-04	February 2022
37	2022-02-05	February 2022
38	2022-02-06	February 2022
39	2022-02-07	February 2022
40	2022-02-08	February 2022
41	2022-02-09	February 2022
42	2022-02-10	February 2022
43	2022-02-11	February 2022
44	2022-02-12	February 2022
45	2022-02-13	February 2022
46	2022-02-14	February 2022
47	2022-02-15	February 2022
48	2022-02-16	February 2022
49	2022-02-17	February 2022
50	2022-02-18	February 2022
51	2022-02-19	February 2022
52	2022-02-20	February 2022
53	2022-02-21	March 2022
54	2022-02-22	March 2022
55	2022-02-23	March 2022
56	2022-02-24	March 2022
57	2022-02-25	March 2022
58	2022-02-26	March 2022
59	2022-02-27	March 2022
60	2022-02-28	March 2022
61	2022-03-01	March 2022
62	2022-03-02	March 2022
63	2022-03-03	March 2022
64	2022-03-04	March 2022
65	2022-03-05	March 2022
66	2022-03-06	March 2022
67	2022-03-07	March 2022
68	2022-03-08	March 2022
69	2022-03-09	March 2022
70	2022-03-10	March 2022
71	2022-03-11	March 2022
72	2022-03-12	March 2022
73	2022-03-13	March 2022
74	2022-03-14	March 2022
75	2022-03-15	March 2022
76	2022-03-16	March 2022
77	2022-03-17	March 2022
78	2022-03-18	March 2022
79	2022-03-19	March 2022
80	2022-03-20	March 2022
81	2022-03-21	April 2022
82	2022-03-22	April 2022
83	2022-03-23	April 2022
84	2022-03-24	April 2022
85	2022-03-25	April 2022
86	2022-03-26	April 2022
87	2022-03-27	April 2022
88	2022-03-28	April 2022
89	2022-03-29	April 2022
90	2022-03-30	April 2022
91	2022-03-31	April 2022
92	2022-04-01	April 2022
93	2022-04-02	April 2022
94	2022-04-03	April 2022
95	2022-04-04	April 2022
96	2022-04-05	April 2022
97	2022-04-06	April 2022
98	2022-04-07	April 2022
99	2022-04-08	April 2022
100	2022-04-09	April 2022
101	2022-04-10	April 2022
102	2022-04-11	April 2022
103	2022-04-12	April 2022
104	2022-04-13	April 2022
105	2022-04-14	April 2022
106	2022-04-15	April 2022
107	2022-04-16	April 2022
108	2022-04-17	April 2022
109	2022-04-18	April 2022
110	2022-04-19	April 2022
111	2022-04-20	April 2022
112	2022-04-21	May 2022
113	2022-04-22	May 2022
114	2022-04-23	May 2022
115	2022-04-24	May 2022
116	2022-04-25	May 2022
117	2022-04-26	May 2022
118	2022-04-27	May 2022
119	2022-04-28	May 2022
120	2022-04-29	May 2022
121	2022-04-30	May 2022
122	2022-05-01	May 2022
123	2022-05-02	May 2022
124	2022-05-03	May 2022
125	2022-05-04	May 2022
126	2022-05-05	May 2022
127	2022-05-06	May 2022
128	2022-05-07	May 2022
129	2022-05-08	May 2022
130	2022-05-09	May 2022
131	2022-05-10	May 2022
132	2022-05-11	May 2022
133	2022-05-12	May 2022
134	2022-05-13	May 2022
135	2022-05-14	May 2022
136	2022-05-15	May 2022
137	2022-05-16	May 2022
138	2022-05-17	May 2022
139	2022-05-18	May 2022
140	2022-05-19	May 2022
141	2022-05-20	May 2022
142	2022-05-21	June 2022
143	2022-05-22	June 2022
144	2022-05-23	June 2022
145	2022-05-24	June 2022
146	2022-05-25	June 2022
147	2022-05-26	June 2022
148	2022-05-27	June 2022
149	2022-05-28	June 2022
150	2022-05-29	June 2022
151	2022-05-30	June 2022
152	2022-05-31	June 2022
153	2022-06-01	June 2022
154	2022-06-02	June 2022
155	2022-06-03	June 2022
156	2022-06-04	June 2022
157	2022-06-05	June 2022
158	2022-06-06	June 2022
159	2022-06-07	June 2022
160	2022-06-08	June 2022
161	2022-06-09	June 2022
162	2022-06-10	June 2022
163	2022-06-11	June 2022
164	2022-06-12	June 2022
165	2022-06-13	June 2022
166	2022-06-14	June 2022
167	2022-06-15	June 2022
168	2022-06-16	June 2022
169	2022-06-17	June 2022
170	2022-06-18	June 2022
171	2022-06-19	June 2022
172	2022-06-20	June 2022
173	2022-06-21	July 2022
174	2022-06-22	July 2022
175	2022-06-23	July 2022
176	2022-06-24	July 2022
177	2022-06-25	July 2022
178	2022-06-26	July 2022
179	2022-06-27	July 2022
180	2022-06-28	July 2022
181	2022-06-29	July 2022
182	2022-06-30	July 2022
183	2022-07-01	July 2022
184	2022-07-02	July 2022
185	2022-07-03	July 2022
186	2022-07-04	July 2022
187	2022-07-05	July 2022
188	2022-07-06	July 2022
189	2022-07-07	July 2022
190	2022-07-08	July 2022
191	2022-07-09	July 2022
192	2022-07-10	July 2022
193	2022-07-11	July 2022
194	2022-07-12	July 2022
195	2022-07-13	July 2022
196	2022-07-14	July 2022
197	2022-07-15	July 2022
198	2022-07-16	July 2022
199	2022-07-17	July 2022
200	2022-07-18	July 2022
201	2022-07-19	July 2022
202	2022-07-20	July 2022
203	2022-07-21	August 2022
204	2022-07-22	August 2022
205	2022-07-23	August 2022
206	2022-07-24	August 2022
207	2022-07-25	August 2022
208	2022-07-26	August 2022
209	2022-07-27	August 2022
210	2022-07-28	August 2022
211	2022-07-29	August 2022
212	2022-07-30	August 2022
213	2022-07-31	August 2022
214	2022-08-01	August 2022
215	2022-08-02	August 2022
216	2022-08-03	August 2022
217	2022-08-04	August 2022
218	2022-08-05	August 2022
219	2022-08-06	August 2022
220	2022-08-07	August 2022
221	2022-08-08	August 2022
222	2022-08-09	August 2022
223	2022-08-10	August 2022
224	2022-08-11	August 2022
225	2022-08-12	August 2022
226	2022-08-13	August 2022
227	2022-08-14	August 2022
228	2022-08-15	August 2022
229	2022-08-16	August 2022
230	2022-08-17	August 2022
231	2022-08-18	August 2022
232	2022-08-19	August 2022
233	2022-08-20	August 2022
234	2022-08-21	September 2022
235	2022-08-22	September 2022
236	2022-08-23	September 2022
237	2022-08-24	September 2022
238	2022-08-25	September 2022
239	2022-08-26	September 2022
240	2022-08-27	September 2022
241	2022-08-28	September 2022
242	2022-08-29	September 2022
243	2022-08-30	September 2022
244	2022-08-31	September 2022
245	2022-09-01	September 2022
246	2022-09-02	September 2022
247	2022-09-03	September 2022
248	2022-09-04	September 2022
249	2022-09-05	September 2022
250	2022-09-06	September 2022
251	2022-09-07	September 2022
252	2022-09-08	September 2022
253	2022-09-09	September 2022
254	2022-09-10	September 2022
255	2022-09-11	September 2022
256	2022-09-12	September 2022
257	2022-09-13	September 2022
258	2022-09-14	September 2022
259	2022-09-15	September 2022
260	2022-09-16	September 2022
261	2022-09-17	September 2022
262	2022-09-18	September 2022
263	2022-09-19	September 2022
264	2022-09-20	September 2022
265	2022-09-21	October 2022
266	2022-09-22	October 2022
267	2022-09-23	October 2022
268	2022-09-24	October 2022
269	2022-09-25	October 2022
270	2022-09-26	October 2022
271	2022-09-27	October 2022
272	2022-09-28	October 2022
273	2022-09-29	October 2022
274	2022-09-30	October 2022
275	2022-10-01	October 2022
276	2022-10-02	October 2022
277	2022-10-03	October 2022
278	2022-10-04	October 2022
279	2022-10-05	October 2022
280	2022-10-06	October 2022
281	2022-10-07	October 2022
282	2022-10-08	October 2022
283	2022-10-09	October 2022
284	2022-10-10	October 2022
285	2022-10-11	October 2022
286	2022-10-12	October 2022
287	2022-10-13	October 2022
288	2022-10-14	October 2022
289	2022-10-15	October 2022
290	2022-10-16	October 2022
291	2022-10-17	October 2022
292	2022-10-18	October 2022
293	2022-10-19	October 2022
294	2022-10-20	October 2022
295	2022-10-21	November 2022
296	2022-10-22	November 2022
297	2022-10-23	November 2022
298	2022-10-24	November 2022
299	2022-10-25	November 2022
300	2022-10-26	November 2022
301	2022-10-27	November 2022
302	2022-10-28	November 2022
303	2022-10-29	November 2022
304	2022-10-30	November 2022
305	2022-10-31	November 2022
306	2022-11-01	November 2022
307	2022-11-02	November 2022
308	2022-11-03	November 2022
309	2022-11-04	November 2022
310	2022-11-05	November 2022
311	2022-11-06	November 2022
312	2022-11-07	November 2022
313	2022-11-08	November 2022
314	2022-11-09	November 2022
315	2022-11-10	November 2022
316	2022-11-11	November 2022
317	2022-11-12	November 2022
318	2022-11-13	November 2022
319	2022-11-14	November 2022
320	2022-11-15	November 2022
321	2022-11-16	November 2022
322	2022-11-17	November 2022
323	2022-11-18	November 2022
324	2022-11-19	November 2022
325	2022-11-20	November 2022
326	2022-11-21	December 2022
327	2022-11-22	December 2022
328	2022-11-23	December 2022
329	2022-11-24	December 2022
330	2022-11-25	December 2022
331	2022-11-26	December 2022
332	2022-11-27	December 2022
333	2022-11-28	December 2022
334	2022-11-29	December 2022
335	2022-11-30	December 2022
336	2022-12-01	December 2022
337	2022-12-02	December 2022
338	2022-12-03	December 2022
339	2022-12-04	December 2022
340	2022-12-05	December 2022
341	2022-12-06	December 2022
342	2022-12-07	December 2022
343	2022-12-08	December 2022
344	2022-12-09	December 2022
345	2022-12-10	December 2022
346	2022-12-11	December 2022
347	2022-12-12	December 2022
348	2022-12-13	December 2022
349	2022-12-14	December 2022
350	2022-12-15	December 2022
351	2022-12-16	December 2022
352	2022-12-17	December 2022
353	2022-12-18	December 2022
354	2022-12-19	December 2022
355	2022-12-20	December 2022
356	2022-12-21	January 2023
357	2022-12-22	January 2023
358	2022-12-23	January 2023
359	2022-12-24	January 2023
360	2022-12-25	January 2023
361	2022-12-26	January 2023
362	2022-12-27	January 2023
363	2022-12-28	January 2023
364	2022-12-29	January 2023
365	2022-12-30	January 2023
366	2022-12-31	January 2023
367	2023-01-01	January 2023
Sheet1

Cell Formulas
Range	Formula
B2:B367	B2	=EOMONTH(A2,--(DAY(A2)>=21))

Awesome, although I am currently not familiar with EOMONTH but will definitely explore. It served the purpose. Thank you so much