Extracting relevant data in Worksheets

[amritamuduli]

In one Worksheet there is data cells (having dd/mm/yy hh:mm format). In another sheet I need to calculate the counts of cells in terms of of months. Ex: 2020 Jan: 12, Feb:22 etc.

 

[Toadstool]

Hi Amritamuduli,

My PC is from the US so the dates may look wrong but it will still work with other formats.

So you'll want to report in January any which are greater than or equal to 1 Jan 2020 00:00 and less than 1 Feb 2020.

I've set the headings for the months as dates being the first of each month with a time of 00:00 so I can run that compare. I also need an extra heading for the last month (December in my example) so it has the correct limiter.

Amritamuduli.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Date & Time		Counts
2	01-Jan-20 2:00		Jan-20	Feb-20	Mar-20	Apr-20	May-20	Jun-20	Jul-20	Aug-20	Sep-20	Oct-20	Nov-20	Dec-20	Jan-21
3	10-Jan-20 5:36		4	3	3	4	0	0	0	0	1	0	0	1
4	19-Jan-20 9:12
5	28-Jan-20 12:48
6	06-Feb-20 16:24
7	15-Feb-20 20:00
8	24-Feb-20 23:36
9	05-Mar-20 3:12
10	14-Mar-20 6:48
11	23-Mar-20 10:24
12	01-Apr-20 14:00
13	10-Apr-20 17:36
14	19-Apr-20 21:12
15	19-Apr-20 21:12
16	19-Sep-20 21:12
17	19-Dec-20 20:12
Sheet1

Cell Formulas
Range	Formula
D2:O2	D2	=EOMONTH(C2,0)+1
C3:N3	C3	=COUNTIFS($A$2:$A$999,">="&C$2,$A$2:$A$999,"<"&D$2)