I want to count number of sales in this month till present & also need to count for only today's sales upto current time.

[sapxl]

Hello Friends, I'm trying to count the number of sales for the current day and current time… Also I want to count number of sales in this current month still the current month is going on currently (i.e, upto present day& time).. if any sales increase in next moment, then counting need to be increased.. using countif function, but unable to do so, can you help me on this. with my formula: SUM(COUNTIFS(D4:D17,">=1-May-20",D4:D17,"<=31-may-20")) It is giving only current month..and when i'm trying to use the below formula for present time updated, it is not giving the expected solution.. =SUM(COUNTIFS(D4:D17,">=1-May-20",D4:D17,"=today()")) Appreciate your help in this regard.

 

[Fluff]

Can you please post some sample data using the XL2BB add-in, it's very difficult to tell why something isn't working from an image.

 

[CA_Punit]

Your syntax is Wrong

">="&DATE(YYYY,MM,DD)

 

[JoeMo]

" when i'm trying to use the below formula for present time updated, it is not giving the expected solution. "

Try:
=SUM(COUNTIFS(D4:D17,">=5/1/2020",D4:D17,"<="&TODAY()))

 

[CA_Punit]

=SUM(COUNTIFS(D4:D17,">=5/1/2020",D4:D17,"<="&TODAY()))

I alway used ">="&DATE(......) way.
Thanks for the new trick. I was not familiar

 

[JoeMo]

I alway used ">="&DATE(......) way.
Thanks for the new trick. I was not familiar

You are welcome - thanks for the reply.

 

[sapxl]

Hi Friends,

Below is the range for the count function

COUNTING ONLY TODAYS NUMBER OF SALES and THIS MONTH NUMBER OF SALES.xlsx
	C	D	E	F	G	H	I	J
4		1-May-20 7:22 PM
5		9-May-20 7:22 PM
6		13-May-20 7:22 PM
7	Date Format I'm using.. >>>>	22-Jun-20 7:22 PM
8	d-mmm-yy	28-Jun-20 7:13 AM
9		29-Jun-20 7:13 AM
10		30-Jun-20 7:13 AM
11		10-Jul-20 7:22 PM
12		11-Jul-20 7:22 PM
13		12-Jul-20 7:22 PM
14		13-Jul-20 7:22 PM
15		14-Jul-20 7:22 PM
16		15-Jul-20 7:22 PM
17		16-Jul-20 7:22 PM
18
19
20
21
22
23	0	3
24
25		COUNT NUMBER OF SALES TAKEN PLACE IN TODAY
26		COUNT NUMBER OF SALES TAKEN PLACE IN THIS MONTH
27
28		Hello Friends,
29		SUM(COUNTIFS(D4:D17,">=1-May-20",D4:D17,"<=31-may-20")) It is giving only current month..and when i'm trying to use the below formula for present time updated, it is not giving the expected solution.. =SUM(COUNTIFS(D4:D17,">=1-May-20",D4:D17,"=today()")) --
Sheet1

Cell Formulas
Range	Formula
C23	C23	=SUM(COUNTIFS(D4:D17,">=1-May-20",D4:D17,"=today()"))
D23	D23	=SUM(COUNTIFS(D4:D17,">=1-May-20",D4:D17,"<=31-may-20"))

 

[Fluff]

Thanks for that
How about

+Fluff New.xlsm
	A	B	C	D
1
2
3
4				1-May-2020 07:22 PM
5				9-May-2020 07:22 PM
6				13-May-2020 07:22 PM
7				22-Jun-2020 07:22 PM
8				28-Jun-2020 07:13 AM
9				29-Jun-2020 07:13 AM
10				30-Jun-2020 07:13 AM
11				10-Jul-2020 07:22 PM
12				11-Jul-2020 07:22 PM
13				12-Jul-2020 07:22 PM
14				13-Jul-2020 07:22 PM
15				14-Jul-2020 07:22 PM
16				15-Jul-2020 07:22 PM
17				16-Jul-2020 07:22 PM
18
19
20
21
22
23			7	3
Main

Cell Formulas
Range	Formula
C23	C23	=COUNTIFS(D4:D17,">=01/05/2020",D4:D17,"<="&TODAY())
D23	D23	=COUNTIFS(D4:D17,">=1-May-20",D4:D17,"<=31-may-20")

 

[Butterfly Asif]

Try it..
For Current Period:
IFERROR(IF(D2=MAX(D:D),COUNT(D:D),""),"")
For Last Day:
IFERROR(IF(D2=MAX(D:D),COUNT(D:D),""),"")
For Last 7 Days:
IFERROR(IF(D2>=TODAY()-7,COUNT(D:D),""),"")

 

[sapxl]

Hi Fluff,
That code is working great, i needed for current month automatically, i do not need to change the month everytime, like today, is the automatically updated function, it currently updating the formula and calculating whatever number of sales or members registered today... similarly for current month automatically it should pickup the current month and update the calculation of number of sales or members in this month when entries are keep on added and the numbers to be increased as per the calculation... hope i have conveyed.