Spreadsheet: 133365d1324363746-using-proper-date-format-for-sumif-and-countif-functions-book1
Sheet: Sheet1

Original Value | Original Currency | Converted Value in SGD | Period Stop |  | Rates
7000 | USD |  | 2011-12-17 00:00:00 |  | USD | 1.30507
50000 | HKD |  | 2011-12-22 00:00:00 |  | HKD | 0.16773
5500 | SGD |  | 2011-12-29 00:00:00 |  | MYR | 0.41
5500 | USD |  | 2011-12-29 00:00:00 |  | INR | 0.02434
13500 | USD |  | 2011-12-31 00:00:00 |  | GBP | 2.02161
8500 | SGD |  | 2011-12-31 00:00:00 |  | AUD | 1.30846
15000 | MYR |  | 2011-12-31 00:00:00 |  | SGD | 1
0 | HKD |  | 2011-12-31 00:00:00
6000 | SGD |  | 2011-12-31 00:00:00
45000 | MYR |  | 2011-12-31 00:00:00
12000 | SGD |  | 2011-12-31 00:00:00
125000 | INR |  | 2011-12-31 00:00:00
25000 | HKD |  | 2011-12-31 00:00:00
1850 | SGD |  | 2011-12-31 00:00:00
10000 | SGD |  | 2011-12-31 00:00:00
7500 | SGD |  | 2012-01-01 00:00:00
22500 | MYR |  | 2012-01-04 00:00:00
15000 | SGD |  | 2012-01-07 00:00:00
15000 | SGD |  | 2012-01-07 00:00:00
6000 | SGD |  | 2012-01-17 00:00:00
250000 | INR |  | 2012-01-21 00:00:00
220000 | INR |  | 2012-01-25 00:00:00
3000 | SGD |  | 2012-01-25 00:00:00
400000 | INR |  | 2012-01-28 00:00:00
6500 | SGD |  | 2012-01-28 00:00:00
175000 | INR |  | 2012-01-29 00:00:00
200000 | INR |  | 2012-01-30 00:00:00
15000 | SGD |  | 2012-01-31 00:00:00
10000 | MYR |  | 2012-01-31 00:00:00
3000 | USD |  | 2012-01-31 00:00:00
387 | GBP |  | 2012-02-06 00:00:00
250000 | INR |  | 2012-02-18 00:00:00
7000 | SGD |  | 2012-02-19 00:00:00
30000 | MYR |  | 2012-02-20 00:00:00
4200 | SGD |  | 2012-02-20 00:00:00
38500 | HKD |  | 2012-02-28 00:00:00
150000 | INR |  | 2012-02-28 00:00:00
13000 | MYR |  | 2012-02-29 00:00:00
11000 | SGD |  | 2012-02-29 00:00:00
9900 | MYR |  | 2012-02-29 00:00:00
175000 | INR |  | 2012-02-29 00:00:00
15000 | MYR |  | 2012-02-29 00:00:00
110000 | INR |  | 2012-03-01 00:00:00
250000 | INR |  | 2012-03-01 00:00:00
200000 | INR |  | 2012-03-02 00:00:00
400000 | INR |  | 2012-03-07 00:00:00
7250 | SGD |  | 2012-03-13 00:00:00
32000 | SGD |  | 2012-03-15 00:00:00
150000 | INR |  | 2012-03-19 00:00:00
400000 | INR |  | 2012-03-27 00:00:00
15500 | SGD |  | 2012-03-30 00:00:00
24000 | SGD |  | 2012-03-30 00:00:00
41200 | HKD |  | 2012-03-31 00:00:00
25000 | MYR |  | 2012-03-31 00:00:00
6500 | SGD |  | 2012-03-31 00:00:00
7250 | SGD |  | 2012-03-31 00:00:00
9500 | SGD |  | 2012-03-31 00:00:00
17600 | SGD |  | 2012-03-31 00:00:00
54167 | HKD |  | 2012-03-31 00:00:00
400000 | INR |  | 2012-03-31 00:00:00
8100 | SGD |  | 2012-03-31 00:00:00
9000 | USD |  | 2012-04-01 00:00:00
2990 | SGD |  | 2012-04-21 00:00:00
30000 | HKD |  | 2012-04-26 00:00:00
250000 | INR |  | 2012-04-29 00:00:00
50000 | INR |  | 2012-04-30 00:00:00
51408 | HKD |  | 2012-04-30 00:00:00
12000 | SGD |  | 2012-04-30 00:00:00
5000 | USD |  | 2012-04-30 00:00:00
21000 | USD |  | 2012-04-30 00:00:00
150000 | INR |  | 2012-05-01 00:00:00
12666 | SGD |  | 2012-05-09 00:00:00
500000 | INR |  | 2012-05-15 00:00:00
0 | INR |  | 2012-05-15 00:00:00
100000 | INR |  | 2012-05-15 00:00:00
150000 | INR |  | 2012-05-15 00:00:00
23000 | SGD |  | 2012-05-29 00:00:00
25500 | SGD |  | 2012-05-30 00:00:00
3196 | SGD |  | 2012-05-30 00:00:00
125000 | INR |  | 2012-05-31 00:00:00
113000 | INR |  | 2012-05-31 00:00:00
300000 | INR |  | 2012-05-31 00:00:00
4000 | SGD |  | 2012-05-31 00:00:00
5000 | SGD |  | 2012-05-31 00:00:00
225000 | INR |  | 2012-06-01 00:00:00
12250 | MYR |  | 2012-06-03 00:00:00
250000 | INR |  | 2012-06-09 00:00:00
250000 | INR |  | 2012-06-13 00:00:00
8200 | SGD |  | 2012-06-16 00:00:00
6000 | SGD |  | 2012-06-20 00:00:00
200000 | INR |  | 2012-06-22 00:00:00
10000 | SGD |  | 2012-06-29 00:00:00
15000 | SGD |  | 2012-06-30 00:00:00
5000 | SGD |  | 2012-06-30 00:00:00
102040 | HKD |  | 2012-06-30 00:00:00
13000 | USD |  | 2012-06-30 00:00:00
20000 | SGD |  | 2012-06-30 00:00:00
100000 | INR |  | 2012-06-30 00:00:00
10000 | SGD |  | 2012-06-30 00:00:00
5000 | SGD |  | 2012-06-30 00:00:00
5000 | SGD |  | 2012-06-30 00:00:00
75000 | INR |  | 2012-06-30 00:00:00
4800 | SGD |  | 2012-06-30 00:00:00
15000 | SGD |  | 2012-06-30 00:00:00
6000 | SGD |  | 2012-06-30 00:00:00
250000 | INR |  | 2012-06-30 00:00:00
3500 | SGD |  | 2012-07-01 00:00:00
4000 | SGD |  | 2012-07-19 00:00:00
15000 | SGD |  | 2012-07-20 00:00:00
200000 | INR |  | 2012-07-30 00:00:00
15000 | SGD |  | 2012-07-31 00:00:00
350000 | INR |  | 2012-07-31 00:00:00
10000 | SGD |  | 2012-07-31 00:00:00
315000 | INR |  | 2012-07-31 00:00:00
7500 | SGD |  | 2012-07-31 00:00:00
3000 | SGD |  | 2012-07-31 00:00:00
200000 | INR |  | 2012-07-31 00:00:00
135000 | INR |  | 2012-07-31 00:00:00
150000 | INR |  | 2012-07-31 00:00:00
12300 | SGD |  | 2012-07-31 00:00:00
8400 | SGD |  | 2012-08-02 00:00:00
8000 | USD |  | 2012-08-21 00:00:00
9270 | SGD |  | 2012-08-25 00:00:00
35000 | SGD |  | 2012-08-28 00:00:00
300000 | INR |  | 2012-08-31 00:00:00
23500 | SGD |  | 2012-08-31 00:00:00
10240 | SGD |  | 2012-08-31 00:00:00
120000 | INR |  | 2012-08-31 00:00:00
6000 | SGD |  | 2012-08-31 00:00:00
100000 | INR |  | 2012-08-31 00:00:00
30000 | MYR |  | 2012-08-31 00:00:00
55000 | MYR |  | 2012-08-31 00:00:00
200000 | INR |  | 2012-08-31 00:00:00
5000 | SGD |  | 2012-09-11 00:00:00
13500 | SGD |  | 2012-09-11 00:00:00
4000 | USD |  | 2012-09-12 00:00:00
250000 | INR |  | 2012-09-13 00:00:00
1000 | USD |  | 2012-09-15 00:00:00
13850 | USD |  | 2012-09-17 00:00:00
13000 | SGD |  | 2012-09-24 00:00:00
8000 | SGD |  | 2012-09-29 00:00:00
25900 | SGD |  | 2012-09-30 00:00:00
100000 | INR |  | 2012-09-30 00:00:00
250000 | INR |  | 2012-09-30 00:00:00
200000 | INR |  | 2012-09-30 00:00:00
360000 | INR |  | 2012-09-30 00:00:00
150000 | INR |  | 2012-09-30 00:00:00
250000 | INR |  | 2012-09-30 00:00:00
23000 | MYR |  | 2012-09-30 00:00:00
200000 | INR |  | 2012-09-30 00:00:00
12000 | SGD |  | 2012-10-07 00:00:00
140000 | INR |  | 2012-10-09 00:00:00
12600 | SGD |  | 2012-10-16 00:00:00
19250 | SGD |  | 2012-10-31 00:00:00
200000 | INR |  | 2012-10-31 00:00:00
67500 | MYR |  | 2012-10-31 00:00:00
8500 | SGD |  | 2012-10-31 00:00:00
13000 | SGD |  | 2012-10-31 00:00:00
10200 | SGD |  | 2012-10-31 00:00:00
26500 | SGD |  | 2012-10-31 00:00:00
25000 | HKD |  | 2012-10-31 00:00:00
2500 | SGD |  | 2012-10-31 00:00:00
22000 | SGD |  | 2012-10-31 00:00:00
5000 | SGD |  | 2012-11-01 00:00:00
6600 | SGD |  | 2012-11-08 00:00:00
18000 | SGD |  | 2012-11-13 00:00:00
150000 | INR |  | 2012-11-22 00:00:00
350000 | INR |  | 2012-11-29 00:00:00
8850 | USD |  | 2012-11-30 00:00:00
4000 | SGD |  | 2012-11-30 00:00:00
8500 | SGD |  | 2012-11-30 00:00:00
220000 | INR |  | 2012-11-30 00:00:00
50000 | MYR |  | 2012-11-30 00:00:00
3460 | AUD |  | 2012-12-01 00:00:00
1000 | AUD |  | 2012-12-01 00:00:00
400000 | INR |  | 2012-12-09 00:00:00
250000 | INR |  | 2012-12-19 00:00:00
3800 | SGD |  | 2012-12-22 00:00:00
400000 | INR |  | 2012-12-31 00:00:00
18000 | SGD |  | 2012-12-31 00:00:00
15000 | SGD |  | 2012-12-31 00:00:00
400000 | INR |  | 2012-12-31 00:00:00
23500 | SGD |  | 2012-12-31 00:00:00
13217 | SGD |  | 2012-12-31 00:00:00
10098 | SGD |  | 2012-12-31 00:00:00
20000 | SGD |  | 2012-12-31 00:00:00
225000 | INR |  | 2012-12-31 00:00:00
450000 | INR |  | 2013-01-05 00:00:00
20000 | SGD |  | 2013-01-16 00:00:00
7500 | USD |  | 2013-01-23 00:00:00
8500 | SGD |  | 2013-01-31 00:00:00
17000 | SGD |  | 2013-01-31 00:00:00
210000 | INR |  | 2013-01-31 00:00:00
15000 | SGD |  | 2013-01-31 00:00:00
250000 | INR |  | 2013-02-09 00:00:00
495000 | INR |  | 2013-02-24 00:00:00
20000 | SGD |  | 2013-02-26 00:00:00
15000 | SGD |  | 2013-02-28 00:00:00
7000 | USD |  | 2013-02-28 00:00:00
15000 | SGD |  | 2013-02-28 00:00:00
300000 | INR |  | 2013-03-01 00:00:00
5050 | SGD |  | 2013-03-07 00:00:00
15000 | SGD |  | 2013-03-29 00:00:00
200000 | INR |  | 2013-03-31 00:00:00
5000 | SGD |  | 2013-03-31 00:00:00
16000 | SGD |  | 2013-03-31 00:00:00
24000 | MYR |  | 2013-04-24 00:00:00
8500 | SGD |  | 2013-04-27 00:00:00
24000 | SGD |  | 2013-04-29 00:00:00
2800 | SGD |  | 2013-04-30 00:00:00
29244 | SGD |  | 2013-04-30 00:00:00
130000 | HKD |  | 2013-05-10 00:00:00
15000 | SGD |  | 2013-05-30 00:00:00
8500 | SGD |  | 2013-05-31 00:00:00
20000 | SGD |  | 2013-05-31 00:00:00
5500 | USD |  | 2013-05-31 00:00:00
400000 | INR |  | 2013-05-31 00:00:00
8500 | SGD |  | 2013-05-31 00:00:00
200000 | INR |  | 2013-05-31 00:00:00
20500 | SGD |  | 2013-06-30 00:00:00
15000 | SGD |  | 2013-06-30 00:00:00
300000 | INR |  | 2013-06-30 00:00:00
12600 | SGD |  | 2013-07-18 00:00:00
15000 | SGD |  | 2013-07-31 00:00:00
14000 | SGD |  | 2013-07-31 00:00:00
2000 | USD |  | 2013-08-01 00:00:00
55000 | MYR |  | 2013-08-18 00:00:00
20000 | SGD |  | 2013-08-31 00:00:00
15000 | SGD |  | 2013-08-31 00:00:00
17000 | SGD |  | 2013-08-31 00:00:00
400000 | INR |  | 2013-08-31 00:00:00
35000 | SGD |  | 2013-09-14 00:00:00
55000 | MYR |  | 2013-09-30 00:00:00
5700 | SGD |  | 2013-10-31 00:00:00
12100 | SGD |  | 2013-11-07 00:00:00
18000 | SGD |  | 2013-12-31 00:00:00
13500 | SGD |  | 2013-12-31 00:00:00
26866 | SGD |  | 2014-02-28 00:00:00
24800 | SGD |  | 2014-03-08 00:00:00
21600 | SGD |  | 2014-06-30 00:00:00
15500 | SGD |  | 2014-09-01 00:00:00
15834 | USD |  | 2015-01-01 00:00:00
20000 | SGD |  | 2015-08-31 00:00:00