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

 

[omer1234]

A

I

I am getting #N/A error for my formula {=SUM((INT(Sheet1!$B$1:$IU$1)=$B6)*(C$3&"-Team"=Sheet1!C5:IU5))}

C11:F14

C11

=SUM((INT($B$1:$AR$1)=$B11)*(C$10&"-Team"=$B$2:$AR$2))

		Total audits
		A
	2/27/2024​	#N/A​

Are you unable to post your Excel file that I can download to see?

Thx

 

[awoohaw]

A





Are you unable to post your Excel file that I can download to see?

Thx

You don't need my excel file. Copy the mini worksheet to your clipboard. Open a new excel sheet and paste it there If you don't have errors there, then just use the structure of the formula to fit your cell range references.

 

[omer1234]

A





Are you unable to post your Excel file that I can download to see?

Thx

I have matched your cells and still get the same error message.....My data is in sheet 1 & I am tabulating in Sheet 2

{=SUM((INT(Sheet1!$B$1:$IU$1)=$B11)*(C$10&"-Team"=Sheet1!$C$5:$IU$5))} ............... I pressed CSE

		Total audits
		A	B	C	D
	2/27/2024​	#N/A​
	2/27/2024​	#N/A​

 

[omer1234]

o

You don't need my excel file. Copy the mini worksheet to your clipboard. Open a new excel sheet and paste it there If you don't have errors there, then just use the structure of the formula to fit your cell range references.

View attachment 107620

k got it

Thx