Another Days Worked Problem

[Wx4usa]

I have a list of service calls by date and amount. Column A is Date, Column B is amount. On a report in row 1 is a header of months>> Jan-20, Feb-20, Mar-20 and so on.

I need a formula to return days worked in cell E2 Jan-20. See image below. Unique days in Jan 20 should be 4.

 

[Wx4usa]

Oh, how would i return a total revenue for Jan-20?

 

[hrayani]

Is this what you want

In cell E2
=SUMIFS($B$2:$B$11,$A$2:$A$11,">="&E$1,$A$2:$A$11,"<="&EOMONTH(E$1,0))

 

[Wx4usa]

Yes, that answers my second question. The first question still puzzles me. How do I return the number of days worked? It should return 4.

 

[Fluff]

How about

+Fluff New.xlsm
	A	B	C	D	E	F
1					01/01/2020	01/02/2020
2	01/01/2020				4	2
3	01/01/2020
4	02/01/2020
5	02/01/2020
6	02/01/2020
7	03/01/2020
8	05/01/2020
9	05/01/2020
10	05/01/2020
11	05/01/2020
12	01/02/2020
13	02/02/2020
14
15
Master

Cell Formulas
Range	Formula
E2:F2	E2	=ROWS(UNIQUE(FILTER($A$2:$A$20,(MONTH($A$2:$A$20)=MONTH(E1))*($A$2:$A$20<>""))))

 

[Wx4usa]

Perfect. I am so grateful. Very nice.

 

[Fluff]

Glad we could help & thanks for the feedback.