Spreadsheet: 234873d1368206379-previous-date-to-most-current-date-book1
Sheet: Sheet1

 | [NAME] showing the count of how many of the previous dates to the most current date there are - already there
 | I need the formula to tell me the previous date to the most current date out of the list (which in this case should be) 3/26/2013 | This is what I came up but wouldn't I need to change it everytime I update this report? I wanted to automatically calculate for me… =LARGE(A7:A169,3)
 | [NAME] showing the count of how many of the current date there are - already there
 | [NAME] showing Most current date out of the list - already there
Welcome Call Created Date
2012-09-18 00:00:00
2012-09-19 00:00:00
2012-09-19 00:00:00
2012-09-24 00:00:00
2012-09-28 00:00:00
2012-09-28 00:00:00
2012-10-01 00:00:00
2012-10-01 00:00:00
2012-10-01 00:00:00
2012-10-03 00:00:00
2012-10-03 00:00:00
2012-10-03 00:00:00
2012-10-03 00:00:00
2012-10-04 00:00:00
2012-10-04 00:00:00
2012-10-04 00:00:00
2012-10-05 00:00:00
2012-10-05 00:00:00
2012-10-08 00:00:00
2012-10-08 00:00:00
2012-10-09 00:00:00
2012-10-09 00:00:00
2012-10-10 00:00:00
2012-10-10 00:00:00
2012-10-10 00:00:00
2012-10-10 00:00:00
2012-10-11 00:00:00
2012-10-12 00:00:00
2012-10-12 00:00:00
2012-10-12 00:00:00
2012-12-07 00:00:00
2012-10-15 00:00:00
2012-10-15 00:00:00
2012-10-15 00:00:00
2012-10-15 00:00:00
2012-10-16 00:00:00
2012-10-16 00:00:00
2012-10-16 00:00:00
2012-10-17 00:00:00
2012-10-17 00:00:00
2012-10-17 00:00:00
2012-10-17 00:00:00
2012-10-18 00:00:00
2012-10-18 00:00:00
2012-10-18 00:00:00
2012-10-18 00:00:00
2012-10-18 00:00:00
2012-10-18 00:00:00
2012-10-19 00:00:00
2012-10-19 00:00:00
2012-10-19 00:00:00
2012-10-22 00:00:00
2012-10-22 00:00:00
2012-10-22 00:00:00
2012-10-23 00:00:00
2012-10-23 00:00:00
2012-10-23 00:00:00
2012-10-24 00:00:00
2012-10-24 00:00:00
2012-10-25 00:00:00
2012-10-25 00:00:00
2012-10-25 00:00:00
2012-10-26 00:00:00
2012-10-26 00:00:00
2012-10-28 00:00:00
2012-10-29 00:00:00
2012-10-30 00:00:00
2012-10-30 00:00:00
2012-10-30 00:00:00
2012-10-30 00:00:00
2012-10-31 00:00:00
2012-10-31 00:00:00
2012-11-01 00:00:00
2012-11-02 00:00:00
2012-11-02 00:00:00
2012-11-05 00:00:00
2012-11-06 00:00:00
2012-11-07 00:00:00
2012-11-07 00:00:00
2012-11-07 00:00:00
2012-11-07 00:00:00
2012-11-07 00:00:00
2012-11-12 00:00:00
2012-11-13 00:00:00
2012-11-13 00:00:00
2012-11-13 00:00:00
2012-11-13 00:00:00
2012-11-14 00:00:00
2012-11-15 00:00:00
2012-11-15 00:00:00
2013-01-31 00:00:00
2012-11-16 00:00:00
2012-11-16 00:00:00
2012-11-16 00:00:00
2012-11-16 00:00:00
2012-11-20 00:00:00
2012-11-20 00:00:00
2012-11-21 00:00:00
2012-11-21 00:00:00
2012-11-26 00:00:00
2012-11-26 00:00:00
2012-11-26 00:00:00
2012-11-26 00:00:00
2012-11-26 00:00:00
2012-11-27 00:00:00
2012-11-28 00:00:00
2012-11-29 00:00:00
2012-11-30 00:00:00
2012-11-30 00:00:00
2012-11-30 00:00:00
2012-12-03 00:00:00
2012-12-03 00:00:00
2012-12-03 00:00:00
2012-12-03 00:00:00
2012-12-04 00:00:00
2012-12-04 00:00:00
2012-12-04 00:00:00
2012-12-04 00:00:00
2012-12-04 00:00:00
2012-12-05 00:00:00
2012-12-05 00:00:00
2012-12-05 00:00:00
2012-12-06 00:00:00
2012-11-15 00:00:00
2012-12-07 00:00:00
2012-10-12 00:00:00
2012-12-10 00:00:00
2012-12-11 00:00:00
2012-12-12 00:00:00
2012-12-13 00:00:00
2012-12-17 00:00:00
2012-12-18 00:00:00
2012-12-19 00:00:00
2012-12-21 00:00:00
2012-12-26 00:00:00
2012-12-26 00:00:00
2012-12-26 00:00:00
2012-12-27 00:00:00
2012-12-27 00:00:00
2012-12-27 00:00:00
2012-12-27 00:00:00
2013-01-02 00:00:00
2013-01-15 00:00:00
2013-01-17 00:00:00
2012-12-10 00:00:00
2013-02-01 00:00:00
2013-02-04 00:00:00
2013-02-05 00:00:00
2013-02-05 00:00:00
2013-02-05 00:00:00
2013-02-15 00:00:00
2013-02-18 00:00:00
2013-02-26 00:00:00
2013-02-28 00:00:00
2013-03-04 00:00:00
2013-03-04 00:00:00
2013-03-07 00:00:00
2013-03-07 00:00:00
2013-03-08 00:00:00
2013-03-26 00:00:00
2013-03-26 00:00:00
2013-03-26 00:00:00
2013-03-28 00:00:00