Count Dates

[omer1234]

Hi,

I have dates in Sheet 1

Column A - 2/27/2024 10:29:03 AM
Column B - 2/27/2024 10:26:33 AM
Column C - 2/27/2024 10:25:55 AM
Column D - 2/26/2024 7:50:50 AM
Column E - 2/25/2024 7:50:50 AM

How do I make excel count the dates ignoring the time stamp?

So it should say I have 3 entries for (2/27), 1 entry for (2/26) and 1 entry for (2/25).

Thanks

 

[awoohaw]

try:
You may need to enter with CNTL-SHFT-ENTR (CSE) keystroke.

Book1
	A	B	C	D	E
1	2024-02-27 10:29:00	2024-02-27 10:26:00	2024-02-27 10:25:00	2024-02-26 07:50:00	2024-02-25 07:50:00
2
3	3	3	3	1	1
Sheet1

Cell Formulas
Range	Formula
A3:E3	A3	=SUM(--(INT($A$1:$E$1)=INT(A1)))

 

[omer1234]

try:
You may need to enter with CNTL-SHFT-ENTR (CSE) keystroke.

Book1
	A	B	C	D	E
1	2024-02-27 10:29:00	2024-02-27 10:26:00	2024-02-27 10:25:00	2024-02-26 07:50:00	2024-02-25 07:50:00
2
3	3	3	3	1	1
Sheet1

Cell Formulas
Range	Formula
A3:E3	A3	=SUM(--(INT($A$1:$E$1)=INT(A1)))

Tried, but that didn't pick up the date

 

[awoohaw]

Your pictures are no help without the formula you used. I can't guess what you did.

 

[omer1234]

Your pictures are no help without the formula you used. I can't guess what you did.

let me try to post the spreasheet itself...... I have n formulas right now, I need help with formulas for all the yellow areas

 

[omer1234]

let me try to post the spreasheet itself...... I have n formulas right now, I need help with formulas for all the yellow areas

 

[omer1234]

How can I insert a file?

 

[awoohaw]

How can I insert a file?

Select your range. Right Click Copy, or CNTL-C, Come to this web page, start a message, click V.

if you want to post a file, you need to share it to Dropbox or OneDrive. Then share the link.

 

[omer1234]

Select your range. Right Click Copy, or CNTL-C, Come to this web page, start a message, click V.

if you want to post a file, you need to share it to Dropbox or OneDrive. Then share the link.

Time Entered

02/27/24 10:29:03​

02/27/24 10:26:33​

02/27/24 09:57:29​

02/27/24 08:30:53​

02/27/24 08:20:24​

02/27/24 08:18:29​

02/27/24 08:15:57​

02/27/24 08:14:25​

02/21/24 12:30:59​

02/21/24 11:18:57​

02/21/24 11:16:35​

02/21/24 11:15:33​

02/21/24 11:13:32​

02/20/24 12:57:30​

02/20/24 12:53:17​

02/20/24 12:50:30​

02/20/24 12:47:40​

02/20/24 12:44:42​

02/20/24 12:38:47​

02/20/24 12:34:21​

02/20/24 12:09:41​

02/20/24 12:08:10​

02/20/24 12:06:29​

02/20/24 12:05:30​

02/20/24 12:03:58​

02/20/24 12:01:26​

02/20/24 11:59:26​

02/20/24 08:08:41​

02/20/24 08:07:28​

02/20/24 08:05:48​

02/20/24 08:01:13​

02/19/24 15:30:54​

02/19/24 15:27:57​

02/19/24 15:26:48​

02/19/24 15:25:10​

02/19/24 15:22:21​

02/19/24 15:20:46​

02/19/24 15:12:29​

02/19/24 14:42:47​

02/19/24 14:40:31​

02/19/24 14:38:01​

02/19/24 14:36:21​

02/19/24 14:34:03​

########​

########​

########​

########​

########​

########​

########​

########​

########​

Team

A-Team

D-Team

A-Team

D-Team

D-Team

D-Team

D-Team

D-Team

A-Team

D-Team

D-Team

D-Team

D-Team

C-Team

C-Team

C-Team

C-Team

C-Team

C-Team

C-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

C-Team

C-Team

C-Team

C-Team

C-Team

C-Team

C-Team

A-Team

A-Team

A-Team

A-Team

A-Team

A-Team

A-Team

Holes

0.00​

0.00​

3.00​

3.00​

0.00​

0.00​

0.00​

0.00​

3.00​

0.00​

0.00​

0.00​

3.00​

0.00​

3.00​

0.00​

0.00​

3.00​

0.00​

0.00​

3.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

3.00​

0.00​

3.00​

0.00​

0.00​

0.00​

3.00​

0.00​

0.00​

3.00​

0.00​

0.00​

0.00​

3.00​

0.00​

0.00​

Wrinkels

0.00​

0.00​

3.00​

3.00​

0.00​

0.00​

0.00​

0.00​

1.00​

0.00​

0.00​

0.00​

3.00​

0.00​

3.00​

0.00​

0.00​

0.00​

0.00​

0.00​

3.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

3.00​

0.00​

3.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

3.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

odor

0.00​

0.00​

3.00​

3.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

3.00​

0.00​

3.00​

0.00​

0.00​

0.00​

0.00​

0.00​

3.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

3.00​

0.00​

3.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

3.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

3 means there was a defect

0 means no defect

1 means borderline

 

[omer1234]

Select your range. Right Click Copy, or CNTL-C, Come to this web page, start a message, click V.

if you want to post a file, you need to share it to Dropbox or OneDrive. Then share the link.

This is pure data.... No formulas (Sheet 1)

Time Entered

02/27/24 10:29:03​

02/27/24 10:26:33​

02/27/24 09:57:29​

02/27/24 08:30:53​

02/27/24 08:20:24​

02/27/24 08:18:29​

02/27/24 08:15:57​

02/27/24 08:14:25​

02/21/24 12:30:59​

02/21/24 11:18:57​

02/21/24 11:16:35​

02/21/24 11:15:33​

02/21/24 11:13:32​

02/20/24 12:57:30​

02/20/24 12:53:17​

02/20/24 12:50:30​

02/20/24 12:47:40​

02/20/24 12:44:42​

02/20/24 12:38:47​

02/20/24 12:34:21​

02/20/24 12:09:41​

02/20/24 12:08:10​

02/20/24 12:06:29​

02/20/24 12:05:30​

02/20/24 12:03:58​

02/20/24 12:01:26​

02/20/24 11:59:26​

02/20/24 08:08:41​

02/20/24 08:07:28​

02/20/24 08:05:48​

02/20/24 08:01:13​

02/19/24 15:30:54​

02/19/24 15:27:57​

02/19/24 15:26:48​

02/19/24 15:25:10​

02/19/24 15:22:21​

02/19/24 15:20:46​

02/19/24 15:12:29​

02/19/24 14:42:47​

02/19/24 14:40:31​

02/19/24 14:38:01​

02/19/24 14:36:21​

02/19/24 14:34:03​

########​

########​

########​

########​

########​

########​

########​

########​

########​

Team

A-Team

D-Team

A-Team

D-Team

D-Team

D-Team

D-Team

D-Team

A-Team

D-Team

D-Team

D-Team

D-Team

C-Team

C-Team

C-Team

C-Team

C-Team

C-Team

C-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

B-Team

C-Team

C-Team

C-Team

C-Team

C-Team

C-Team

C-Team

A-Team

A-Team

A-Team

A-Team

A-Team

A-Team

A-Team

Holes

0.00​

0.00​

3.00​

3.00​

0.00​

0.00​

0.00​

0.00​

3.00​

0.00​

0.00​

0.00​

3.00​

0.00​

3.00​

0.00​

0.00​

3.00​

0.00​

0.00​

3.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

3.00​

0.00​

3.00​

0.00​

0.00​

0.00​

3.00​

0.00​

0.00​

3.00​

0.00​

0.00​

0.00​

3.00​

0.00​

0.00​

Wrinkels

0.00​

0.00​

3.00​

3.00​

0.00​

0.00​

0.00​

0.00​

1.00​

0.00​

0.00​

0.00​

3.00​

0.00​

3.00​

0.00​

0.00​

0.00​

0.00​

0.00​

3.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

3.00​

0.00​

3.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

3.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

odor

0.00​

0.00​

3.00​

3.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

3.00​

0.00​

3.00​

0.00​

0.00​

0.00​

0.00​

0.00​

3.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

3.00​

0.00​

3.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

3.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

3 means there was a defect

0 means no defect

1 means borderline