Spreadsheet: 220662d1363220093-searching-for-a-min-value-in-a-month-and-posting-it-beside-the-previous-month-example-sheet
Sheet: Sheet1

Date | Num | Amount at end of following Month | Amount at Start of following Month | Cell @ End of Following Month | Cell @ Start of Following Month
2013-03-01 00:00:00 | 518.8800000000001
2013-03-02 00:00:00 | 503.4500000000001 |  |  |  |  | <-- want to use these cell referances in a "Min" function to determine the min amount during that month
2013-03-03 00:00:00 | 422.2300000000001
2013-03-04 00:00:00 | 673.9600000000002
2013-03-05 00:00:00 | 428.4700000000001
2013-03-06 00:00:00 | 368.9000000000001
2013-03-07 00:00:00 | 93.15000000000015
2013-03-08 00:00:00 | 1244.55
2013-03-09 00:00:00 | 1208.65
2013-03-10 00:00:00 | 867.0499999999998
2013-03-11 00:00:00 | 792.9899999999998
2013-03-12 00:00:00 | 784.3799999999998
2013-03-13 00:00:00 | 605.4599999999998
2013-03-14 00:00:00 | 570.4599999999998
2013-03-15 00:00:00 | 570.4599999999998
2013-03-16 00:00:00 | 570.4599999999998
2013-03-17 00:00:00 | 570.4599999999998
2013-03-18 00:00:00 | 535.4599999999998
2013-03-19 00:00:00 | 535.4599999999998
2013-03-20 00:00:00 | 485.4599999999998
2013-03-21 00:00:00 | 450.4599999999998
2013-03-22 00:00:00 | 1590.27
2013-03-23 00:00:00 | 1567.77
2013-03-24 00:00:00 | 1532.77
2013-03-25 00:00:00 | 1497.77
2013-03-26 00:00:00 | 1497.77
2013-03-27 00:00:00 | 1447.77
2013-03-28 00:00:00 | 1412.77
2013-03-29 00:00:00 | 959.7699999999998
2013-03-30 00:00:00 | 959.7699999999998
2013-03-31 00:00:00 | 959.7699999999998
2013-04-01 00:00:00 | 374
2013-04-02 00:00:00 | 374.7699999999998
2013-04-03 00:00:00 | 174.7699999999998
2013-04-04 00:00:00 | 139.7699999999998
2013-04-05 00:00:00 | 1299.58
2013-04-06 00:00:00 | 1257.24
2013-04-07 00:00:00 | 1007.24
2013-04-08 00:00:00 | 972.2399999999998
2013-04-09 00:00:00 | 972.2399999999998
2013-04-10 00:00:00 | 922.2399999999998
2013-04-11 00:00:00 | 887.2399999999998
2013-04-12 00:00:00 | 887.2399999999998
2013-04-13 00:00:00 | 887.2399999999998
2013-04-14 00:00:00 | 887.2399999999998
2013-04-15 00:00:00 | 852.2399999999998
2013-04-16 00:00:00 | 852.2399999999998
2013-04-17 00:00:00 | 802.2399999999998
2013-04-18 00:00:00 | 767.2399999999998
2013-04-19 00:00:00 | 1907.05
2013-04-20 00:00:00 | 1884.55
2013-04-21 00:00:00 | 1849.55
2013-04-22 00:00:00 | 1814.55
2013-04-23 00:00:00 | 1814.55
2013-04-24 00:00:00 | 1764.55
2013-04-25 00:00:00 | 1729.55
2013-04-26 00:00:00 | 1729.55
2013-04-27 00:00:00 | 1729.55
2013-04-28 00:00:00 | 1729.55
2013-04-29 00:00:00 | 1694.55
2013-04-30 00:00:00 | 1694
2013-05-01 00:00:00 | 387
2013-05-02 00:00:00 | 352.3399999999997
2013-05-03 00:00:00 | 1512.15
2013-05-04 00:00:00 | 1362.15
2013-05-05 00:00:00 | 1362.15
2013-05-06 00:00:00 | 1284.81
2013-05-07 00:00:00 | 1034.81
2013-05-08 00:00:00 | 984.8099999999997
2013-05-09 00:00:00 | 949.8099999999997
2013-05-10 00:00:00 | 949.8099999999997
2013-05-11 00:00:00 | 949.8099999999997
2013-05-12 00:00:00 | 949.8099999999997
2013-05-13 00:00:00 | 914.8099999999997
2013-05-14 00:00:00 | 914.8099999999997
2013-05-15 00:00:00 | 864.8099999999997
2013-05-16 00:00:00 | 829.8099999999997
2013-05-17 00:00:00 | 1969.62
2013-05-18 00:00:00 | 1947.12
2013-05-19 00:00:00 | 1912.12
2013-05-20 00:00:00 | 1877.12
2013-05-21 00:00:00 | 1877.12
2013-05-22 00:00:00 | 1827.12
2013-05-23 00:00:00 | 1792.12
2013-05-24 00:00:00 | 1792.12
2013-05-25 00:00:00 | 1792.12
2013-05-26 00:00:00 | 1792.12
2013-05-27 00:00:00 | 1757.12
2013-05-28 00:00:00 | 1757.12
2013-05-29 00:00:00 | 1707.12
2013-05-30 00:00:00 | 1672.12
2013-05-31 00:00:00 | 2831