Count of unique Dates in range by Month and year

[PrachiOU]

I have a hourly date range for a year, I am trying to find the latest month with the data of whole month:
For eg i have data from 3rd Jan 2020 to 5th Feb 2021 and I need the latest month as Jan 2021

Is there as way to do this in excel.

 

[Peter_SSs]

Welcome to the MrExcel board!

What if you had data to 28 Feb 2021?
Would we have to check
- to see if the latest time was, say 11:00 PM for the answer to be Feb 2021 or
- would the answer already be decided as Feb 2021 or
- Jan 2021

BTW, I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.

 

[PrachiOU]

Thankyou for replying Peter_SSs,
In my file I have daily data of each hour(so it will have whole 24hours data for 28). if the latest time was11:00 PM for the answer to be Feb 2021 it should select Feb 2021
Else for any other day in Feb like 27th, 15th etc, it should select Jan 2021.

Adding only the data of Jan and Feb 2021 date and hour due to mini sheet limitations:

Test.xlsx
	A	B
1	Day	Hour of Day
2	1/1/2021	12:00 AM
3	1/1/2021	1:00 AM
4	1/1/2021	2:00 AM
5	1/1/2021	3:00 AM
6	1/1/2021	4:00 AM
7	1/1/2021	5:00 AM
8	1/1/2021	6:00 AM
9	1/1/2021	7:00 AM
10	1/1/2021	8:00 AM
11	1/1/2021	9:00 AM
12	1/1/2021	10:00 AM
13	1/1/2021	11:00 AM
14	1/1/2021	12:00 PM
15	1/1/2021	1:00 PM
16	1/1/2021	2:00 PM
17	1/1/2021	3:00 PM
18	1/1/2021	4:00 PM
19	1/1/2021	5:00 PM
20	1/1/2021	6:00 PM
21	1/1/2021	7:00 PM
22	1/1/2021	8:00 PM
23	1/1/2021	9:00 PM
24	1/1/2021	10:00 PM
25	1/1/2021	11:00 PM
26	1/2/2021	12:00 AM
27	1/2/2021	1:00 AM
28	1/2/2021	2:00 AM
29	1/2/2021	3:00 AM
30	1/2/2021	4:00 AM
31	1/2/2021	5:00 AM
32	1/2/2021	6:00 AM
33	1/2/2021	7:00 AM
34	1/2/2021	8:00 AM
35	1/2/2021	9:00 AM
36	1/2/2021	10:00 AM
37	1/2/2021	11:00 AM
38	1/2/2021	12:00 PM
39	1/2/2021	1:00 PM
40	1/2/2021	2:00 PM
41	1/2/2021	3:00 PM
42	1/2/2021	4:00 PM
43	1/2/2021	5:00 PM
44	1/2/2021	6:00 PM
45	1/2/2021	7:00 PM
46	1/2/2021	8:00 PM
47	1/2/2021	9:00 PM
48	1/2/2021	10:00 PM
49	1/2/2021	11:00 PM
50	1/3/2021	12:00 AM
51	1/3/2021	1:00 AM
52	1/3/2021	2:00 AM
53	1/3/2021	3:00 AM
54	1/3/2021	4:00 AM
55	1/3/2021	5:00 AM
56	1/3/2021	6:00 AM
57	1/3/2021	7:00 AM
58	1/3/2021	8:00 AM
59	1/3/2021	9:00 AM
60	1/3/2021	10:00 AM
61	1/3/2021	11:00 AM
62	1/3/2021	12:00 PM
63	1/3/2021	1:00 PM
64	1/3/2021	2:00 PM
65	1/3/2021	3:00 PM
66	1/3/2021	4:00 PM
67	1/3/2021	5:00 PM
68	1/3/2021	6:00 PM
69	1/3/2021	7:00 PM
70	1/3/2021	8:00 PM
71	1/3/2021	9:00 PM
72	1/3/2021	10:00 PM
73	1/3/2021	11:00 PM
74	1/4/2021	12:00 AM
75	1/4/2021	1:00 AM
76	1/4/2021	2:00 AM
77	1/4/2021	3:00 AM
78	1/4/2021	4:00 AM
79	1/4/2021	5:00 AM
80	1/4/2021	6:00 AM
81	1/4/2021	7:00 AM
82	1/4/2021	8:00 AM
83	1/4/2021	9:00 AM
84	1/4/2021	10:00 AM
85	1/4/2021	11:00 AM
86	1/4/2021	12:00 PM
87	1/4/2021	1:00 PM
88	1/4/2021	2:00 PM
89	1/4/2021	3:00 PM
90	1/4/2021	4:00 PM
91	1/4/2021	5:00 PM
92	1/4/2021	6:00 PM
93	1/4/2021	7:00 PM
94	1/4/2021	8:00 PM
95	1/4/2021	9:00 PM
96	1/4/2021	10:00 PM
97	1/4/2021	11:00 PM
98	1/5/2021	12:00 AM
99	1/5/2021	1:00 AM
100	1/5/2021	2:00 AM
101	1/5/2021	3:00 AM
102	1/5/2021	4:00 AM
103	1/5/2021	5:00 AM
104	1/5/2021	6:00 AM
105	1/5/2021	7:00 AM
106	1/5/2021	8:00 AM
107	1/5/2021	9:00 AM
108	1/5/2021	10:00 AM
109	1/5/2021	11:00 AM
110	1/5/2021	12:00 PM
111	1/5/2021	1:00 PM
112	1/5/2021	2:00 PM
113	1/5/2021	3:00 PM
114	1/5/2021	4:00 PM
115	1/5/2021	5:00 PM
116	1/5/2021	6:00 PM
117	1/5/2021	7:00 PM
118	1/5/2021	8:00 PM
119	1/5/2021	9:00 PM
120	1/5/2021	10:00 PM
121	1/5/2021	11:00 PM
122	1/6/2021	12:00 AM
123	1/6/2021	1:00 AM
124	1/6/2021	2:00 AM
125	1/6/2021	3:00 AM
126	1/6/2021	4:00 AM
127	1/6/2021	5:00 AM
128	1/6/2021	6:00 AM
129	1/6/2021	7:00 AM
130	1/6/2021	8:00 AM
131	1/6/2021	9:00 AM
132	1/6/2021	10:00 AM
133	1/6/2021	11:00 AM
134	1/6/2021	12:00 PM
135	1/6/2021	1:00 PM
136	1/6/2021	2:00 PM
137	1/6/2021	3:00 PM
138	1/6/2021	4:00 PM
139	1/6/2021	5:00 PM
140	1/6/2021	6:00 PM
141	1/6/2021	7:00 PM
142	1/6/2021	8:00 PM
143	1/6/2021	9:00 PM
144	1/6/2021	10:00 PM
145	1/6/2021	11:00 PM
146	1/7/2021	12:00 AM
147	1/7/2021	1:00 AM
148	1/7/2021	2:00 AM
149	1/7/2021	3:00 AM
150	1/7/2021	4:00 AM
151	1/7/2021	5:00 AM
152	1/7/2021	6:00 AM
153	1/7/2021	7:00 AM
154	1/7/2021	8:00 AM
155	1/7/2021	9:00 AM
156	1/7/2021	10:00 AM
157	1/7/2021	11:00 AM
158	1/7/2021	12:00 PM
159	1/7/2021	1:00 PM
160	1/7/2021	2:00 PM
161	1/7/2021	3:00 PM
162	1/7/2021	4:00 PM
163	1/7/2021	5:00 PM
164	1/7/2021	6:00 PM
165	1/7/2021	7:00 PM
166	1/7/2021	8:00 PM
167	1/7/2021	9:00 PM
168	1/7/2021	10:00 PM
169	1/7/2021	11:00 PM
170	1/8/2021	12:00 AM
171	1/8/2021	1:00 AM
172	1/8/2021	2:00 AM
173	1/8/2021	3:00 AM
174	1/8/2021	4:00 AM
175	1/8/2021	5:00 AM
176	1/8/2021	6:00 AM
177	1/8/2021	7:00 AM
178	1/8/2021	8:00 AM
179	1/8/2021	9:00 AM
180	1/8/2021	10:00 AM
181	1/8/2021	11:00 AM
182	1/8/2021	12:00 PM
183	1/8/2021	1:00 PM
184	1/8/2021	2:00 PM
185	1/8/2021	3:00 PM
186	1/8/2021	4:00 PM
187	1/8/2021	5:00 PM
188	1/8/2021	6:00 PM
189	1/8/2021	7:00 PM
190	1/8/2021	8:00 PM
191	1/8/2021	9:00 PM
192	1/8/2021	10:00 PM
193	1/8/2021	11:00 PM
194	1/9/2021	12:00 AM
195	1/9/2021	1:00 AM
196	1/9/2021	2:00 AM
197	1/9/2021	3:00 AM
198	1/9/2021	4:00 AM
199	1/9/2021	5:00 AM
200	1/9/2021	6:00 AM
201	1/9/2021	7:00 AM
202	1/9/2021	8:00 AM
203	1/9/2021	9:00 AM
204	1/9/2021	10:00 AM
205	1/9/2021	11:00 AM
206	1/9/2021	12:00 PM
207	1/9/2021	1:00 PM
208	1/9/2021	2:00 PM
209	1/9/2021	3:00 PM
210	1/9/2021	4:00 PM
211	1/9/2021	5:00 PM
212	1/9/2021	6:00 PM
213	1/9/2021	7:00 PM
214	1/9/2021	8:00 PM
215	1/9/2021	9:00 PM
216	1/9/2021	10:00 PM
217	1/9/2021	11:00 PM
218	1/10/2021	12:00 AM
219	1/10/2021	1:00 AM
220	1/10/2021	2:00 AM
221	1/10/2021	3:00 AM
222	1/10/2021	4:00 AM
223	1/10/2021	5:00 AM
224	1/10/2021	6:00 AM
225	1/10/2021	7:00 AM
226	1/10/2021	8:00 AM
227	1/10/2021	9:00 AM
228	1/10/2021	10:00 AM
229	1/10/2021	11:00 AM
230	1/10/2021	12:00 PM
231	1/10/2021	1:00 PM
232	1/10/2021	2:00 PM
233	1/10/2021	3:00 PM
234	1/10/2021	4:00 PM
235	1/10/2021	5:00 PM
236	1/10/2021	6:00 PM
237	1/10/2021	7:00 PM
238	1/10/2021	8:00 PM
239	1/10/2021	9:00 PM
240	1/10/2021	10:00 PM
241	1/10/2021	11:00 PM
242	1/11/2021	12:00 AM
243	1/11/2021	1:00 AM
244	1/11/2021	2:00 AM
245	1/11/2021	3:00 AM
246	1/11/2021	4:00 AM
247	1/11/2021	5:00 AM
248	1/11/2021	6:00 AM
249	1/11/2021	7:00 AM
250	1/11/2021	8:00 AM
251	1/11/2021	9:00 AM
252	1/11/2021	10:00 AM
253	1/11/2021	11:00 AM
254	1/11/2021	12:00 PM
255	1/11/2021	1:00 PM
256	1/11/2021	2:00 PM
257	1/11/2021	3:00 PM
258	1/11/2021	4:00 PM
259	1/11/2021	5:00 PM
260	1/11/2021	6:00 PM
261	1/11/2021	7:00 PM
262	1/11/2021	8:00 PM
263	1/11/2021	9:00 PM
264	1/11/2021	10:00 PM
265	1/11/2021	11:00 PM
266	1/12/2021	12:00 AM
267	1/12/2021	1:00 AM
268	1/12/2021	2:00 AM
269	1/12/2021	3:00 AM
270	1/12/2021	4:00 AM
271	1/12/2021	5:00 AM
272	1/12/2021	6:00 AM
273	1/12/2021	7:00 AM
274	1/12/2021	8:00 AM
275	1/12/2021	9:00 AM
276	1/12/2021	10:00 AM
277	1/12/2021	11:00 AM
278	1/12/2021	12:00 PM
279	1/12/2021	1:00 PM
280	1/12/2021	2:00 PM
281	1/12/2021	3:00 PM
282	1/12/2021	4:00 PM
283	1/12/2021	5:00 PM
284	1/12/2021	6:00 PM
285	1/12/2021	7:00 PM
286	1/12/2021	8:00 PM
287	1/12/2021	9:00 PM
288	1/12/2021	10:00 PM
289	1/12/2021	11:00 PM
290	1/13/2021	12:00 AM
291	1/13/2021	1:00 AM
292	1/13/2021	2:00 AM
293	1/13/2021	3:00 AM
294	1/13/2021	4:00 AM
295	1/13/2021	5:00 AM
296	1/13/2021	6:00 AM
297	1/13/2021	7:00 AM
298	1/13/2021	8:00 AM
299	1/13/2021	9:00 AM
300	1/13/2021	10:00 AM
301	1/13/2021	11:00 AM
302	1/13/2021	12:00 PM
303	1/13/2021	1:00 PM
304	1/13/2021	2:00 PM
305	1/13/2021	3:00 PM
306	1/13/2021	4:00 PM
307	1/13/2021	5:00 PM
308	1/13/2021	6:00 PM
309	1/13/2021	7:00 PM
310	1/13/2021	8:00 PM
311	1/13/2021	9:00 PM
312	1/13/2021	10:00 PM
313	1/13/2021	11:00 PM
314	1/14/2021	12:00 AM
315	1/14/2021	1:00 AM
316	1/14/2021	2:00 AM
317	1/14/2021	3:00 AM
318	1/14/2021	4:00 AM
319	1/14/2021	5:00 AM
320	1/14/2021	6:00 AM
321	1/14/2021	7:00 AM
322	1/14/2021	8:00 AM
323	1/14/2021	9:00 AM
324	1/14/2021	10:00 AM
325	1/14/2021	11:00 AM
326	1/14/2021	12:00 PM
327	1/14/2021	1:00 PM
328	1/14/2021	2:00 PM
329	1/14/2021	3:00 PM
330	1/14/2021	4:00 PM
331	1/14/2021	5:00 PM
332	1/14/2021	6:00 PM
333	1/14/2021	7:00 PM
334	1/14/2021	8:00 PM
335	1/14/2021	9:00 PM
336	1/14/2021	10:00 PM
337	1/14/2021	11:00 PM
338	1/15/2021	12:00 AM
339	1/15/2021	1:00 AM
340	1/15/2021	2:00 AM
341	1/15/2021	3:00 AM
342	1/15/2021	4:00 AM
343	1/15/2021	5:00 AM
344	1/15/2021	6:00 AM
345	1/15/2021	7:00 AM
346	1/15/2021	8:00 AM
347	1/15/2021	9:00 AM
348	1/15/2021	10:00 AM
349	1/15/2021	11:00 AM
350	1/15/2021	12:00 PM
351	1/15/2021	1:00 PM
352	1/15/2021	2:00 PM
353	1/15/2021	3:00 PM
354	1/15/2021	4:00 PM
355	1/15/2021	5:00 PM
356	1/15/2021	6:00 PM
357	1/15/2021	7:00 PM
358	1/15/2021	8:00 PM
359	1/15/2021	9:00 PM
360	1/15/2021	10:00 PM
361	1/15/2021	11:00 PM
362	1/16/2021	12:00 AM
363	1/16/2021	1:00 AM
364	1/16/2021	2:00 AM
365	1/16/2021	3:00 AM
366	1/16/2021	4:00 AM
367	1/16/2021	5:00 AM
368	1/16/2021	6:00 AM
369	1/16/2021	7:00 AM
370	1/16/2021	8:00 AM
371	1/16/2021	9:00 AM
372	1/16/2021	10:00 AM
373	1/16/2021	11:00 AM
374	1/16/2021	12:00 PM
375	1/16/2021	1:00 PM
376	1/16/2021	2:00 PM
377	1/16/2021	3:00 PM
378	1/16/2021	4:00 PM
379	1/16/2021	5:00 PM
380	1/16/2021	6:00 PM
381	1/16/2021	7:00 PM
382	1/16/2021	8:00 PM
383	1/16/2021	9:00 PM
384	1/16/2021	10:00 PM
385	1/16/2021	11:00 PM
386	1/17/2021	12:00 AM
387	1/17/2021	1:00 AM
388	1/17/2021	2:00 AM
389	1/17/2021	3:00 AM
390	1/17/2021	4:00 AM
391	1/17/2021	5:00 AM
392	1/17/2021	6:00 AM
393	1/17/2021	7:00 AM
394	1/17/2021	8:00 AM
395	1/17/2021	9:00 AM
396	1/17/2021	10:00 AM
397	1/17/2021	11:00 AM
398	1/17/2021	12:00 PM
399	1/17/2021	1:00 PM
400	1/17/2021	2:00 PM
401	1/17/2021	3:00 PM
402	1/17/2021	4:00 PM
403	1/17/2021	5:00 PM
404	1/17/2021	6:00 PM
405	1/17/2021	7:00 PM
406	1/17/2021	8:00 PM
407	1/17/2021	9:00 PM
408	1/17/2021	10:00 PM
409	1/17/2021	11:00 PM
410	1/18/2021	12:00 AM
411	1/18/2021	1:00 AM
412	1/18/2021	2:00 AM
413	1/18/2021	3:00 AM
414	1/18/2021	4:00 AM
415	1/18/2021	5:00 AM
416	1/18/2021	6:00 AM
417	1/18/2021	7:00 AM
418	1/18/2021	8:00 AM
419	1/18/2021	9:00 AM
420	1/18/2021	10:00 AM
421	1/18/2021	11:00 AM
422	1/18/2021	12:00 PM
423	1/18/2021	1:00 PM
424	1/18/2021	2:00 PM
425	1/18/2021	3:00 PM
426	1/18/2021	4:00 PM
427	1/18/2021	5:00 PM
428	1/18/2021	6:00 PM
429	1/18/2021	7:00 PM
430	1/18/2021	8:00 PM
431	1/18/2021	9:00 PM
432	1/18/2021	10:00 PM
433	1/18/2021	11:00 PM
434	1/19/2021	12:00 AM
435	1/19/2021	1:00 AM
436	1/19/2021	2:00 AM
437	1/19/2021	3:00 AM
438	1/19/2021	4:00 AM
439	1/19/2021	5:00 AM
440	1/19/2021	6:00 AM
441	1/19/2021	7:00 AM
442	1/19/2021	8:00 AM
443	1/19/2021	9:00 AM
444	1/19/2021	10:00 AM
445	1/19/2021	11:00 AM
446	1/19/2021	12:00 PM
447	1/19/2021	1:00 PM
448	1/19/2021	2:00 PM
449	1/19/2021	3:00 PM
450	1/19/2021	4:00 PM
451	1/19/2021	5:00 PM
452	1/19/2021	6:00 PM
453	1/19/2021	7:00 PM
454	1/19/2021	8:00 PM
455	1/19/2021	9:00 PM
456	1/19/2021	10:00 PM
457	1/19/2021	11:00 PM
458	1/20/2021	12:00 AM
459	1/20/2021	1:00 AM
460	1/20/2021	2:00 AM
461	1/20/2021	3:00 AM
462	1/20/2021	4:00 AM
463	1/20/2021	5:00 AM
464	1/20/2021	6:00 AM
465	1/20/2021	7:00 AM
466	1/20/2021	8:00 AM
467	1/20/2021	9:00 AM
468	1/20/2021	10:00 AM
469	1/20/2021	11:00 AM
470	1/20/2021	12:00 PM
471	1/20/2021	1:00 PM
472	1/20/2021	2:00 PM
473	1/20/2021	3:00 PM
474	1/20/2021	4:00 PM
475	1/20/2021	5:00 PM
476	1/20/2021	6:00 PM
477	1/20/2021	7:00 PM
478	1/20/2021	8:00 PM
479	1/20/2021	9:00 PM
480	1/20/2021	10:00 PM
481	1/20/2021	11:00 PM
482	1/21/2021	12:00 AM
483	1/21/2021	1:00 AM
484	1/21/2021	2:00 AM
485	1/21/2021	3:00 AM
486	1/21/2021	4:00 AM
487	1/21/2021	5:00 AM
488	1/21/2021	6:00 AM
489	1/21/2021	7:00 AM
490	1/21/2021	8:00 AM
491	1/21/2021	9:00 AM
492	1/21/2021	10:00 AM
493	1/21/2021	11:00 AM
494	1/21/2021	12:00 PM
495	1/21/2021	1:00 PM
496	1/21/2021	2:00 PM
497	1/21/2021	3:00 PM
498	1/21/2021	4:00 PM
499	1/21/2021	5:00 PM
500	1/21/2021	6:00 PM
501	1/21/2021	7:00 PM
502	1/21/2021	8:00 PM
503	1/21/2021	9:00 PM
504	1/21/2021	10:00 PM
505	1/21/2021	11:00 PM
506	1/22/2021	12:00 AM
507	1/22/2021	1:00 AM
508	1/22/2021	2:00 AM
509	1/22/2021	3:00 AM
510	1/22/2021	4:00 AM
511	1/22/2021	5:00 AM
512	1/22/2021	6:00 AM
513	1/22/2021	7:00 AM
514	1/22/2021	8:00 AM
515	1/22/2021	9:00 AM
516	1/22/2021	10:00 AM
517	1/22/2021	11:00 AM
518	1/22/2021	12:00 PM
519	1/22/2021	1:00 PM
520	1/22/2021	2:00 PM
521	1/22/2021	3:00 PM
522	1/22/2021	4:00 PM
523	1/22/2021	5:00 PM
524	1/22/2021	6:00 PM
525	1/22/2021	7:00 PM
526	1/22/2021	8:00 PM
527	1/22/2021	9:00 PM
528	1/22/2021	10:00 PM
529	1/22/2021	11:00 PM
530	1/23/2021	12:00 AM
531	1/23/2021	1:00 AM
532	1/23/2021	2:00 AM
533	1/23/2021	3:00 AM
534	1/23/2021	4:00 AM
535	1/23/2021	5:00 AM
536	1/23/2021	6:00 AM
537	1/23/2021	7:00 AM
538	1/23/2021	8:00 AM
539	1/23/2021	9:00 AM
540	1/23/2021	10:00 AM
541	1/23/2021	11:00 AM
542	1/23/2021	12:00 PM
543	1/23/2021	1:00 PM
544	1/23/2021	2:00 PM
545	1/23/2021	3:00 PM
546	1/23/2021	4:00 PM
547	1/23/2021	5:00 PM
548	1/23/2021	6:00 PM
549	1/23/2021	7:00 PM
550	1/23/2021	8:00 PM
551	1/23/2021	9:00 PM
552	1/23/2021	10:00 PM
553	1/23/2021	11:00 PM
554	1/24/2021	12:00 AM
555	1/24/2021	1:00 AM
556	1/24/2021	2:00 AM
557	1/24/2021	3:00 AM
558	1/24/2021	4:00 AM
559	1/24/2021	5:00 AM
560	1/24/2021	6:00 AM
561	1/24/2021	7:00 AM
562	1/24/2021	8:00 AM
563	1/24/2021	9:00 AM
564	1/24/2021	10:00 AM
565	1/24/2021	11:00 AM
566	1/24/2021	12:00 PM
567	1/24/2021	1:00 PM
568	1/24/2021	2:00 PM
569	1/24/2021	3:00 PM
570	1/24/2021	4:00 PM
571	1/24/2021	5:00 PM
572	1/24/2021	6:00 PM
573	1/24/2021	7:00 PM
574	1/24/2021	8:00 PM
575	1/24/2021	9:00 PM
576	1/24/2021	10:00 PM
577	1/24/2021	11:00 PM
578	1/25/2021	12:00 AM
579	1/25/2021	1:00 AM
580	1/25/2021	2:00 AM
581	1/25/2021	3:00 AM
582	1/25/2021	4:00 AM
583	1/25/2021	5:00 AM
584	1/25/2021	6:00 AM
585	1/25/2021	7:00 AM
586	1/25/2021	8:00 AM
587	1/25/2021	9:00 AM
588	1/25/2021	10:00 AM
589	1/25/2021	11:00 AM
590	1/25/2021	12:00 PM
591	1/25/2021	1:00 PM
592	1/25/2021	2:00 PM
593	1/25/2021	3:00 PM
594	1/25/2021	4:00 PM
595	1/25/2021	5:00 PM
596	1/25/2021	6:00 PM
597	1/25/2021	7:00 PM
598	1/25/2021	8:00 PM
599	1/25/2021	9:00 PM
600	1/25/2021	10:00 PM
601	1/25/2021	11:00 PM
602	1/26/2021	12:00 AM
603	1/26/2021	1:00 AM
604	1/26/2021	2:00 AM
605	1/26/2021	3:00 AM
606	1/26/2021	4:00 AM
607	1/26/2021	5:00 AM
608	1/26/2021	6:00 AM
609	1/26/2021	7:00 AM
610	1/26/2021	8:00 AM
611	1/26/2021	9:00 AM
612	1/26/2021	10:00 AM
613	1/26/2021	11:00 AM
614	1/26/2021	12:00 PM
615	1/26/2021	1:00 PM
616	1/26/2021	2:00 PM
617	1/26/2021	3:00 PM
618	1/26/2021	4:00 PM
619	1/26/2021	5:00 PM
620	1/26/2021	6:00 PM
621	1/26/2021	7:00 PM
622	1/26/2021	8:00 PM
623	1/26/2021	9:00 PM
624	1/26/2021	10:00 PM
625	1/26/2021	11:00 PM
626	1/27/2021	12:00 AM
627	1/27/2021	1:00 AM
628	1/27/2021	2:00 AM
629	1/27/2021	3:00 AM
630	1/27/2021	4:00 AM
631	1/27/2021	5:00 AM
632	1/27/2021	6:00 AM
633	1/27/2021	7:00 AM
634	1/27/2021	8:00 AM
635	1/27/2021	9:00 AM
636	1/27/2021	10:00 AM
637	1/27/2021	11:00 AM
638	1/27/2021	12:00 PM
639	1/27/2021	1:00 PM
640	1/27/2021	2:00 PM
641	1/27/2021	3:00 PM
642	1/27/2021	4:00 PM
643	1/27/2021	5:00 PM
644	1/27/2021	6:00 PM
645	1/27/2021	7:00 PM
646	1/27/2021	8:00 PM
647	1/27/2021	9:00 PM
648	1/27/2021	10:00 PM
649	1/27/2021	11:00 PM
650	1/28/2021	12:00 AM
651	1/28/2021	1:00 AM
652	1/28/2021	2:00 AM
653	1/28/2021	3:00 AM
654	1/28/2021	4:00 AM
655	1/28/2021	5:00 AM
656	1/28/2021	6:00 AM
657	1/28/2021	7:00 AM
658	1/28/2021	8:00 AM
659	1/28/2021	9:00 AM
660	1/28/2021	10:00 AM
661	1/28/2021	11:00 AM
662	1/28/2021	12:00 PM
663	1/28/2021	1:00 PM
664	1/28/2021	2:00 PM
665	1/28/2021	3:00 PM
666	1/28/2021	4:00 PM
667	1/28/2021	5:00 PM
668	1/28/2021	6:00 PM
669	1/28/2021	7:00 PM
670	1/28/2021	8:00 PM
671	1/28/2021	9:00 PM
672	1/28/2021	10:00 PM
673	1/28/2021	11:00 PM
674	1/29/2021	12:00 AM
675	1/29/2021	1:00 AM
676	1/29/2021	2:00 AM
677	1/29/2021	3:00 AM
678	1/29/2021	4:00 AM
679	1/29/2021	5:00 AM
680	1/29/2021	6:00 AM
681	1/29/2021	7:00 AM
682	1/29/2021	8:00 AM
683	1/29/2021	9:00 AM
684	1/29/2021	10:00 AM
685	1/29/2021	11:00 AM
686	1/29/2021	12:00 PM
687	1/29/2021	1:00 PM
688	1/29/2021	2:00 PM
689	1/29/2021	3:00 PM
690	1/29/2021	4:00 PM
691	1/29/2021	5:00 PM
692	1/29/2021	6:00 PM
693	1/29/2021	7:00 PM
694	1/29/2021	8:00 PM
695	1/29/2021	9:00 PM
696	1/29/2021	10:00 PM
697	1/29/2021	11:00 PM
698	1/30/2021	12:00 AM
699	1/30/2021	1:00 AM
700	1/30/2021	2:00 AM
701	1/30/2021	3:00 AM
702	1/30/2021	4:00 AM
703	1/30/2021	5:00 AM
704	1/30/2021	6:00 AM
705	1/30/2021	7:00 AM
706	1/30/2021	8:00 AM
707	1/30/2021	9:00 AM
708	1/30/2021	10:00 AM
709	1/30/2021	11:00 AM
710	1/30/2021	12:00 PM
711	1/30/2021	1:00 PM
712	1/30/2021	2:00 PM
713	1/30/2021	3:00 PM
714	1/30/2021	4:00 PM
715	1/30/2021	5:00 PM
716	1/30/2021	6:00 PM
717	1/30/2021	7:00 PM
718	1/30/2021	8:00 PM
719	1/30/2021	9:00 PM
720	1/30/2021	10:00 PM
721	1/30/2021	11:00 PM
722	1/31/2021	12:00 AM
723	1/31/2021	1:00 AM
724	1/31/2021	2:00 AM
725	1/31/2021	3:00 AM
726	1/31/2021	4:00 AM
727	1/31/2021	5:00 AM
728	1/31/2021	6:00 AM
729	1/31/2021	7:00 AM
730	1/31/2021	8:00 AM
731	1/31/2021	9:00 AM
732	1/31/2021	10:00 AM
733	1/31/2021	11:00 AM
734	1/31/2021	12:00 PM
735	1/31/2021	1:00 PM
736	1/31/2021	2:00 PM
737	1/31/2021	3:00 PM
738	1/31/2021	4:00 PM
739	1/31/2021	5:00 PM
740	1/31/2021	6:00 PM
741	1/31/2021	7:00 PM
742	1/31/2021	8:00 PM
743	1/31/2021	9:00 PM
744	1/31/2021	10:00 PM
745	1/31/2021	11:00 PM
746	2/1/2021	12:00 AM
747	2/1/2021	1:00 AM
748	2/1/2021	2:00 AM
749	2/1/2021	3:00 AM
750	2/1/2021	4:00 AM
751	2/1/2021	5:00 AM
752	2/1/2021	6:00 AM
753	2/1/2021	7:00 AM
754	2/1/2021	8:00 AM
755	2/1/2021	9:00 AM
756	2/1/2021	10:00 AM
757	2/1/2021	11:00 AM
758	2/1/2021	12:00 PM
759	2/1/2021	1:00 PM
760	2/1/2021	2:00 PM
761	2/1/2021	3:00 PM
762	2/1/2021	4:00 PM
763	2/1/2021	5:00 PM
764	2/1/2021	6:00 PM
765	2/1/2021	7:00 PM
766	2/1/2021	8:00 PM
767	2/1/2021	9:00 PM
768	2/1/2021	10:00 PM
769	2/1/2021	11:00 PM
770	2/2/2021	12:00 AM
771	2/2/2021	1:00 AM
772	2/2/2021	2:00 AM
773	2/2/2021	3:00 AM
774	2/2/2021	4:00 AM
775	2/2/2021	5:00 AM
776	2/2/2021	6:00 AM
777	2/2/2021	7:00 AM
778	2/2/2021	8:00 AM
779	2/2/2021	9:00 AM
780	2/2/2021	10:00 AM
781	2/2/2021	11:00 AM
782	2/2/2021	12:00 PM
783	2/2/2021	1:00 PM
784	2/2/2021	2:00 PM
785	2/2/2021	3:00 PM
786	2/2/2021	4:00 PM
787	2/2/2021	5:00 PM
788	2/2/2021	6:00 PM
789	2/2/2021	7:00 PM
790	2/2/2021	8:00 PM
791	2/2/2021	9:00 PM
792	2/2/2021	10:00 PM
793	2/2/2021	11:00 PM
794	2/3/2021	12:00 AM
795	2/3/2021	1:00 AM
796	2/3/2021	2:00 AM
797	2/3/2021	3:00 AM
798	2/3/2021	4:00 AM
799	2/3/2021	5:00 AM
800	2/3/2021	6:00 AM
801	2/3/2021	7:00 AM
802	2/3/2021	8:00 AM
803	2/3/2021	9:00 AM
804	2/3/2021	10:00 AM
805	2/3/2021	11:00 AM
806	2/3/2021	12:00 PM
807	2/3/2021	1:00 PM
808	2/3/2021	2:00 PM
809	2/3/2021	3:00 PM
810	2/3/2021	4:00 PM
811	2/3/2021	5:00 PM
812	2/3/2021	6:00 PM
813	2/3/2021	7:00 PM
814	2/3/2021	8:00 PM
815	2/3/2021	9:00 PM
816	2/3/2021	10:00 PM
817	2/3/2021	11:00 PM
818	2/4/2021	12:00 AM
819	2/4/2021	1:00 AM
820	2/4/2021	2:00 AM
821	2/4/2021	3:00 AM
822	2/4/2021	4:00 AM
823	2/4/2021	5:00 AM
824	2/4/2021	6:00 AM
825	2/4/2021	7:00 AM
826	2/4/2021	8:00 AM
827	2/4/2021	9:00 AM
828	2/4/2021	10:00 AM
829	2/4/2021	11:00 AM
830	2/4/2021	12:00 PM
831	2/4/2021	1:00 PM
832	2/4/2021	2:00 PM
833	2/4/2021	3:00 PM
834	2/4/2021	4:00 PM
835	2/4/2021	5:00 PM
836	2/4/2021	6:00 PM
837	2/4/2021	7:00 PM
838	2/4/2021	8:00 PM
839	2/4/2021	9:00 PM
840	2/4/2021	10:00 PM
841	2/4/2021	11:00 PM
842	2/5/2021	12:00 AM
843	2/5/2021	1:00 AM
844	2/5/2021	2:00 AM
845	2/5/2021	3:00 AM
846	2/5/2021	4:00 AM
847	2/5/2021	5:00 AM
848	2/5/2021	6:00 AM
849	2/5/2021	7:00 AM
850	2/5/2021	8:00 AM
851	2/5/2021	9:00 AM
852	2/5/2021	10:00 AM
853	2/5/2021	11:00 AM
854	2/5/2021	12:00 PM
855	2/5/2021	1:00 PM
856	2/5/2021	2:00 PM
857	2/5/2021	3:00 PM
858	2/5/2021	4:00 PM
859	2/5/2021	5:00 PM
860	2/5/2021	6:00 PM
861	2/5/2021	7:00 PM
862	2/5/2021	8:00 PM
863	2/5/2021	9:00 PM
864	2/5/2021	10:00 PM
865	2/5/2021	11:00 PM
Usage

 

[Peter_SSs]

See if this does what you want.

=TEXT(EDATE(LOOKUP(9^9,A:A),(LOOKUP(9^9,A:A)=EOMONTH(LOOKUP(9^9,A:A),0))-1),"mmm yyyy")

 

[PrachiOU]

See if this does what you want.

=TEXT(EDATE(LOOKUP(9^9,A:A),(LOOKUP(9^9,A:A)=EOMONTH(LOOKUP(9^9,A:A),0))-1),"mmm yyyy")

Thankyou for the prompt help Peter_SSs
I updated my range in the above code u gave and its giving me Dec 2019 and Dec 2019 is not in my Date range.

 

[PrachiOU]

Thankyou for the prompt help Peter_SSs
I updated my range in the above code u gave and its giving me Dec 2019 and Dec 2019 is not in my Date range.

Peter_SSs, thanks a ton for the code i updated it to following and its working:

=TEXT(EDATE(MAX(Dates),(MAX(Dates)=EOMONTH(MAX(Dates),0))-1),"mmm yyyy")

 

[Peter_SSs]

Glad you got it to work. Thanks for letting us know.