Help with Date comparison

niraj4

New Member
Joined
Mar 21, 2007
Messages
11
Hi,


I want to check the amount earned per month (Oct 2010 to MArch 2011) by using a formula

R4=SUMPRODUCT(('Survey Income 2010-11'!$C6:$C2000)*('Survey Income 2010-11'!$F6:$F2000="Y")*('Survey Income 2010-11'!$E6:$E2000>=Dashboard!$AA6)*('Survey Income 2010-11'!$E6:$E2000<=Dashboard!$AB6))

AA6 = 11/1/2010
AB6 = 11/30/2010

The formula is not able to compare the dates. Where am I going wrong? Please help!


Content of Survey Income 2010-11 sheet:


A B C D E
Sr. No. Description Amount Details Date Income Taxable Income (INR)
1 Survey Income from SPONSOR $1.50 Survey Income from AN 31 March, 2011 Y INR 75.00
2 Survey Income from SPONSOR $1.50 Survey Income from SS 31 March, 2011 Y INR 75.00
3 Survey Income from SPONSOR $1.50 Survey Income from SS 31 March, 2011 Y INR 75.00
4 Survey Income from SPONSOR $1.50 Survey Income from PV 30 March, 2011 Y INR 75.00
5 Survey Income from SPONSOR $1.50 Survey Income from PV 30 March, 2011 Y INR 75.00
6 Survey Income from SPONSOR $1.50 Survey Income from NK 29 March, 2011 Y INR 75.00
7 Survey Income from SPONSOR $1.50 Survey Income from NK 29 March, 2011 Y INR 75.00
8 Survey Income from SPONSOR $1.50 Survey Income from SS 29 March, 2011 Y INR 75.00
9 Survey Income from SPONSOR $1.50 Survey Income from CV 29 March, 2011 Y INR 75.00
10 Survey Income from SPONSOR $1.50 Survey Income from CV 29 March, 2011 Y INR 75.00
11 Survey Income from SPONSOR $1.50 Survey Income from VN 28 March, 2011 Y INR 75.00
12 Survey Income from SPONSOR $1.50 Survey Income from VN 28 March, 2011 Y INR 75.00
13 Survey Income from SPONSOR $1.50 Survey Income from NS 27 March, 2011 Y INR 75.00
14 Survey Income from SPONSOR $1.50 Survey Income from NS 27 March, 2011 Y INR 75.00
15 Survey Income $10.00 Survey Income 27 March, 2011 Y INR 500.00
16 Survey Income $10.00 Survey Income 27 March, 2011 Y INR 500.00
17 Survey Income from SPONSOR $1.50 Survey Income from SS 26 March, 2011 Y INR 75.00
18 Survey Income $10.00 Survey Income 26 March, 2011 Y INR 500.00
19 Survey Income $10.00 Survey Income 26 March, 2011 Y INR 500.00
20 CASH REQUEST RAISED $499.00 Raise Cash Request of $ 499 26 March, 2011 N INR 0.00
21 FUNDS RECEIVED $286.00 Funds received from your Panel E-Wallet to Survey E-Wallet. Amount: $ 286 26 March, 2011 N INR 0.00
22 Survey Income from SPONSOR $1.50 Survey Income from CV 24 March, 2011 Y INR 75.00
23 Survey Income from SPONSOR $1.50 Survey Income from CV 24 March, 2011 Y INR 75.00
24 Survey Income from SPONSOR $1.50 Survey Income from AN 24 March, 2011 Y INR 75.00
25 Survey Income from SPONSOR $1.50 Survey Income from PV 22 March, 2011 Y INR 75.00
26 Survey Income from SPONSOR $1.50 Survey Income from PV 22 March, 2011 Y INR 75.00
27 Survey Income from SPONSOR $1.50 Survey Income from VN 21 March, 2011 Y INR 75.00
28 Survey Income from SPONSOR $1.50 Survey Income from VN 21 March, 2011 Y INR 75.00
29 Survey Income from SPONSOR $1.50 Survey Income from AN 21 March, 2011 Y INR 75.00
30 Survey Income from SPONSOR $1.50 Survey Income from NK 21 March, 2011 Y INR 75.00
31 Survey Income from SPONSOR $1.50 Survey Income from NK 21 March, 2011 Y INR 75.00
32 Survey Income from SPONSOR $1.50 Survey Income from AN 20 March, 2011 Y INR 75.00
33 Survey Income from SPONSOR $1.50 Survey Income from AN 20 March, 2011 Y INR 75.00
34 Survey Income from SPONSOR $1.50 Survey Income from NS 20 March, 2011 Y INR 75.00
35 Survey Income from SPONSOR $1.50 Survey Income from NS 20 March, 2011 Y INR 75.00
36 Survey Income from SPONSOR $1.50 Survey Income from SS 18 March, 2011 Y INR 75.00
37 Survey Income $10.00 Survey Income 18 March, 2011 Y INR 500.00
38 Survey Income from SPONSOR $1.50 Survey Income from VN 15 March, 2011 Y INR 75.00
39 Survey Income from SPONSOR $1.50 Survey Income from VN 15 March, 2011 Y INR 75.00
40 Survey Income from SPONSOR $1.50 Survey Income from PV 15 March, 2011 Y INR 75.00
41 Survey Income from SPONSOR $1.50 Survey Income from PV 15 March, 2011 Y INR 75.00
42 Survey Income from SPONSOR $1.50 Survey Income from CV 15 March, 2011 Y INR 75.00
43 Survey Income from SPONSOR $1.50 Survey Income from CV 15 March, 2011 Y INR 75.00
44 Survey Income from SPONSOR $1.50 Survey Income from NK 14 March, 2011 Y INR 75.00
45 Survey Income from SPONSOR $1.50 Survey Income from NK 14 March, 2011 Y INR 75.00
46 Survey Income $10.00 Survey Income 14 March, 2011 Y INR 500.00
47 Survey Income from SPONSOR $1.50 Survey Income from NS 13 March, 2011 Y INR 75.00
48 Survey Income from SPONSOR $1.50 Survey Income from NS 13 March, 2011 Y INR 75.00
49 Survey Income from SPONSOR $1.50 Survey Income from SS 13 March, 2011 Y INR 75.00
50 Survey Income from SPONSOR $1.50 Survey Income from NK 7 March, 2011 Y INR 75.00
51 Survey Income from SPONSOR $1.50 Survey Income from SS 7 March, 2011 Y INR 75.00
52 Survey Income from SPONSOR $1.50 Survey Income from SS 7 March, 2011 Y INR 75.00
53 Survey Income from SPONSOR $1.50 Survey Income from PV 7 March, 2011 Y INR 75.00
54 Survey Income from SPONSOR $1.50 Survey Income from PV 7 March, 2011 Y INR 75.00
55 Survey Income from SPONSOR $1.50 Survey Income from CV 7 March, 2011 Y INR 75.00
56 Survey Income from SPONSOR $1.50 Survey Income from CV 7 March, 2011 Y INR 75.00
57 Survey Income from SPONSOR $1.50 Survey Income from AN 6 March, 2011 Y INR 75.00
58 Survey Income from SPONSOR $1.50 Survey Income from AN 6 March, 2011 Y INR 75.00
59 Survey Income from SPONSOR $1.50 Survey Income from NS 6 March, 2011 Y INR 75.00
60 Survey Income from SPONSOR $1.50 Survey Income from NS 6 March, 2011 Y INR 75.00
61 Survey Income from SPONSOR $1.50 Survey Income from NK 6 March, 2011 Y INR 75.00
62 Survey Income $10.00 Survey Income 5 March, 2011 Y INR 500.00
63 Survey Income $10.00 Survey Income 5 March, 2011 Y INR 500.00
64 Survey Income from SPONSOR $1.50 Survey Income from NK 2 March, 2011 Y INR 75.00
65 Survey Income from SPONSOR $1.50 Survey Income from NK 2 March, 2011 Y INR 75.00
66 Survey Income from SPONSOR $1.50 Survey Income from AN 28 February, 2011 Y INR 75.00
67 Survey Income $10.00 Survey Income 28 February, 2011 Y INR 500.00
68 Survey Income $10.00 Survey Income 28 February, 2011 Y INR 500.00
69 Survey Income from SPONSOR $1.50 Survey Income from CV 28 February, 2011 Y INR 75.00
70 Survey Income from SPONSOR $1.50 Survey Income from CV 28 February, 2011 Y INR 75.00
71 Survey Income from SPONSOR $1.50 Survey Income from AN 27 February, 2011 Y INR 75.00
72 Survey Income from SPONSOR $1.50 Survey Income from SS 26 February, 2011 Y INR 75.00
73 Survey Income from SPONSOR $1.50 Survey Income from SS 26 February, 2011 Y INR 75.00
74 Survey Income from SPONSOR $1.50 Survey Income from SS 26 February, 2011 Y INR 75.00
75 Survey Income from SPONSOR $1.50 Survey Income from SS 26 February, 2011 Y INR 75.00
76 Survey Income from SPONSOR $1.50 Survey Income from NS 26 February, 2011 Y INR 75.00
77 Survey Income from SPONSOR $1.50 Survey Income from NS 26 February, 2011 Y INR 75.00
78 Survey Income from SPONSOR $1.50 Survey Income from PV 26 February, 2011 Y INR 75.00
79 Survey Income from SPONSOR $1.50 Survey Income from PV 26 February, 2011 Y INR 75.00
80 Survey Income from SPONSOR $1.50 Survey Income from CV 24 February, 2011 Y INR 75.00
81 Survey Income from SPONSOR $1.50 Survey Income from CV 24 February, 2011 Y INR 75.00
82 Survey Income from SPONSOR $1.50 Survey Income from NK 23 February, 2011 Y INR 75.00
83 Survey Income from SPONSOR $1.50 Survey Income from AN 22 February, 2011 Y INR 75.00
84 Survey Income from SPONSOR $1.50 Survey Income from AN 22 February, 2011 Y INR 75.00
85 Survey Income $10.00 Survey Income 21 February, 2011 Y INR 500.00
86 Survey Income $10.00 Survey Income 21 February, 2011 Y INR 500.00
87 Survey Income from SPONSOR $1.50 Survey Income from CV 21 February, 2011 Y INR 75.00
88 Survey Income from SPONSOR $1.50 Survey Income from CV 21 February, 2011 Y INR 75.00
89 Survey Income from SPONSOR $1.50 Survey Income from AN 20 February, 2011 Y INR 75.00
90 Survey Income from SPONSOR $1.50 Survey Income from AN 20 February, 2011 Y INR 75.00
91 Survey Income from SPONSOR $1.50 Survey Income from PV 20 February, 2011 Y INR 75.00
92 Survey Income from SPONSOR $1.50 Survey Income from PV 20 February, 2011 Y INR 75.00
93 Survey Income from SPONSOR $1.50 Survey Income from NK 20 February, 2011 Y INR 75.00
94 Survey Income from SPONSOR $1.50 Survey Income from SS 19 February, 2011 Y INR 75.00
95 Survey Income from SPONSOR $1.50 Survey Income from CV 18 February, 2011 Y INR 75.00
96 Survey Income from SPONSOR $1.50 Survey Income from CV 18 February, 2011 Y INR 75.00
97 Survey Income from SPONSOR $1.50 Survey Income from CV 17 February, 2011 Y INR 75.00
98 Survey Income from SPONSOR $1.50 Survey Income from CV 17 February, 2011 Y INR 75.00
99 Survey Income from SPONSOR $1.50 Survey Income from SS 16 February, 2011 Y INR 75.00
100 Survey Income from SPONSOR $1.50 Survey Income from PV 15 February, 2011 Y INR 75.00
101 Survey Income from SPONSOR $1.50 Survey Income from PV 15 February, 2011 Y INR 75.00
102 Survey Income from SPONSOR $1.50 Survey Income from PV 15 February, 2011 Y INR 75.00
103 Survey Income from SPONSOR $1.50 Survey Income from PV 15 February, 2011 Y INR 75.00
104 Survey Income $10.00 Survey Income 13 February, 2011 Y INR 500.00
105 Survey Income $10.00 Survey Income 13 February, 2011 Y INR 500.00
106 Income from Conference Ticket $2.00 Conference Ticket Income $ 2 9 February, 2011 Y INR 100.00
107 Generate Ticket For Conference $80.00 Ticket For Conference $ 80 9 February, 2011 N INR 0.00
108 FUNDS RECEIVED $40.00 Funds received from your Panel E-Wallet to Survey E-Wallet. Amount: $ 40 8 February, 2011 N INR 0.00
109 Survey Income $10.00 Survey Income 7 February, 2011 Y INR 500.00
110 Survey Income $10.00 Survey Income 7 February, 2011 Y INR 500.00
111 Survey Income $10.00 Survey Income 1 February, 2011 Y INR 500.00
112 Survey Income $10.00 Survey Income 1 February, 2011 Y INR 500.00
113 CASH REQUEST RAISED $413.00 Raise Cash Request of $ 413 25 January, 2011 N INR 0.00
114 FUNDS RECEIVED $180.00 Funds received from your Panel E-Wallet to Survey E-Wallet. Amount: $ 180 25 January, 2011 N INR 0.00
115 Survey Income $10.00 Survey Income 24 January, 2011 Y INR 500.00
116 Survey Income $10.00 Survey Income 24 January, 2011 Y INR 500.00
117 Survey Income $10.00 Survey Income 24 January, 2011 Y INR 500.00
118 Survey Income from SPONSOR $1.50 Survey Income from CV 23 January, 2011 Y INR 75.00
119 Survey Income from SPONSOR $1.50 Survey Income from CV 23 January, 2011 Y INR 75.00
120 subscription code income $1.00 Generate Subscription Code $40 Income $1 22 January, 2011 Y INR 50.00
121 GENERATE SUBSCRIPTION CODE $40.00 Generate Subscription Code of $40 22 January, 2011 N INR 0.00
122 FUNDS RECEIVED $40.00 Funds received from your Panel E-Wallet to Survey E-Wallet. Amount: $ 40 22 January, 2011 N INR 0.00
123 subscription code income $5.50 Generate Subscription Code $220 Income $5.5 20 January, 2011 Y INR 275.00
124 GENERATE SUBSCRIPTION CODE $220.00 Generate Subscription Code of $220 20 January, 2011 N INR 0.00
125 Survey Income from SPONSOR $1.50 Survey Income from CV 19 January, 2011 Y INR 75.00
126 FUNDS RECEIVED $200.00 Funds received from your Panel E-Wallet to Survey E-Wallet. Amount: $ 200 18 January, 2011 N INR 0.00
127 Survey Income from SPONSOR $1.50 Survey Income from CV 18 January, 2011 Y INR 75.00
128 Survey Income from SPONSOR $1.50 Survey Income from CV 18 January, 2011 Y INR 75.00
129 Survey Income $10.00 Survey Income 18 January, 2011 Y INR 500.00
130 Survey Income from SPONSOR $1.50 Survey Income from CV 18 January, 2011 Y INR 75.00
131 Survey Income from SPONSOR $1.50 Survey Income from CV 18 January, 2011 Y INR 75.00
132 Survey Income from SPONSOR $1.50 Survey Income from CV 14 January, 2011 Y INR 75.00
133 Survey Income from SPONSOR $1.50 Survey Income from CV 14 January, 2011 Y INR 75.00
134 Survey Income $10.00 Survey Income 10 January, 2011 Y INR 500.00
135 Survey Income $10.00 Survey Income 10 January, 2011 Y INR 500.00
136 Survey Income $10.00 Survey Income 6 January, 2011 Y INR 500.00
137 Survey Income $10.00 Survey Income 4 January, 2011 Y INR 500.00
138 Survey Income $10.00 Survey Income 31 December, 2010 Y INR 500.00
139 Survey Income $10.00 Survey Income 31 December, 2010 Y INR 500.00
140 Survey Income from SPONSOR $1.50 Survey Income from CV 26 December, 2010 Y INR 75.00
141 Survey Income from SPONSOR $1.50 Survey Income from CV 25 December, 2010 Y INR 75.00
142 Survey Income from SPONSOR $1.50 Survey Income from CV 25 December, 2010 Y INR 75.00
143 Survey Income $10.00 Survey Income 23 December, 2010 Y INR 500.00
144 Survey Income $10.00 Survey Income 23 December, 2010 Y INR 500.00
145 Survey Income from SPONSOR $1.50 Survey Income from CV 21 December, 2010 Y INR 75.00
146 Survey Income $10.00 Survey Income 13 December, 2010 Y INR 500.00
147 Survey Income $10.00 Survey Income 13 December, 2010 Y INR 500.00
148 Survey Income from SPONSOR $1.50 Survey Income from CV 12 December, 2010 Y INR 75.00
149 Survey Income $10.00 Survey Income 8 December, 2010 Y INR 500.00
150 Survey Income $10.00 Survey Income 8 December, 2010 Y INR 500.00
151 Survey Income from SPONSOR $1.50 Survey Income from CV 5 December, 2010 Y INR 75.00
152 Survey Income from SPONSOR $1.50 Survey Income from CV 5 December, 2010 Y INR 75.00
153 Survey Income from SPONSOR $1.50 Survey Income from CV 28 November, 2010 Y INR 75.00
154 Survey Income from SPONSOR $1.50 Survey Income from CV 28 November, 2010 Y INR 75.00
155 Survey Income $10.00 Survey Income 28 November, 2010 Y INR 500.00
156 Survey Income $10.00 Survey Income 28 November, 2010 Y INR 500.00
157 Survey Income $10.00 Survey Income 20 November, 2010 Y INR 500.00
158 Survey Income $10.00 Survey Income 20 November, 2010 Y INR 500.00
159 Survey Income $10.00 Survey Income 14 November, 2010 Y INR 500.00
160 Survey Income $10.00 Survey Income 14 November, 2010 Y INR 500.00
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Forum statistics

Threads
1,214,976
Messages
6,122,541
Members
449,089
Latest member
davidcom

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top