Spreadsheet: 270219d1381416702-trying-to-find-the-max-date-within-each-month-and-its-corresponding-value-daily-production
Sheet: 3-6

UNIQUE ID | LEASE | ID | DATE | BOPD | BWPD
 | NDPU | 3-6 | 2002-01-26 00:00:00 | - | -
 | NDPU | 3-6 | 2002-02-20 00:00:00 | - | -
 | NDPU | 3-6 | 2002-02-26 00:00:00 | 10 | 16
 | NDPU | 3-6 | 2002-03-08 00:00:00 | 11 | 15
 | NDPU | 3-6 | 2002-03-24 00:00:00 | - | -
 | NDPU | 3-6 | 2002-04-19 00:00:00 | 24 | 57
 | NDPU | 3-6 | 2002-05-05 00:00:00 | - | -
 | NDPU | 3-6 | 2002-05-28 00:00:00 | 14 | 26
 | NDPU | 3-6 | 2002-06-19 00:00:00 | 44 | 110
 | NDPU | 3-6 | 2002-06-19 00:00:00 | - | -
 | NDPU | 3-6 | 2002-08-03 00:00:00 | 13 | 24
 | NDPU | 3-6 | 2002-10-06 00:00:00 | 12 | 32
 | NDPU | 3-6 | 2002-10-23 00:00:00 | - | -
 | NDPU | 3-6 | 2002-11-09 00:00:00 | - | -
 | NDPU | 3-6 | 2002-11-27 00:00:00 | - | -
 | NDPU | 3-6 | 2003-04-05 00:00:00 | - | -
 | NDPU | 3-6 | 2003-06-01 00:00:00 | 14 | 36
 | NDPU | 3-6 | 2003-06-21 00:00:00 | 16 | 42
 | NDPU | 3-6 | 2003-07-20 00:00:00 | 18 | 37
 | NDPU | 3-6 | 2003-07-20 00:00:00 | - | -
 | NDPU | 3-6 | 2003-09-23 00:00:00 | - | -
 | NDPU | 3-6 | 2003-10-02 00:00:00 | - | -
 | NDPU | 3-6 | 2003-10-08 00:00:00 | - | -
 | NDPU | 3-6 | 2003-10-09 00:00:00 | 42 | 1365
 | NDPU | 3-6 | 2003-10-09 00:00:00 | - | -
 | NDPU | 3-6 | 2003-10-14 00:00:00 | 13 | 42
 | NDPU | 3-6 | 2003-10-16 00:00:00 | - | -
 | NDPU | 3-6 | 2003-10-18 00:00:00 | - | -
 | NDPU | 3-6 | 2003-10-21 00:00:00 | 15 | 32
 | NDPU | 3-6 | 2003-10-22 00:00:00 | - | -
 | NDPU | 3-6 | 2003-11-01 00:00:00 | - | -
 | NDPU | 3-6 | 2003-11-12 00:00:00 | - | -
 | NDPU | 3-6 | 2003-11-15 00:00:00 | - | -
 | NDPU | 3-6 | 2003-12-05 00:00:00 | - | -
 | NDPU | 3-6 | 2003-12-09 00:00:00 | 12 | 39
 | NDPU | 3-6 | 2004-01-10 00:00:00 | 15 | 31
 | NDPU | 3-6 | 2004-01-11 00:00:00 | - | -
 | NDPU | 3-6 | 2004-01-16 00:00:00 | 10 | 43
 | NDPU | 3-6 | 2004-01-17 00:00:00 | 10 | 43
 | NDPU | 3-6 | 2004-01-26 00:00:00 | - | -
 | NDPU | 3-6 | 2004-02-10 00:00:00 | - | -
 | NDPU | 3-6 | 2004-03-01 00:00:00 | 9 | 24
 | NDPU | 3-6 | 2004-03-03 00:00:00 | - | -
 | NDPU | 3-6 | 2004-03-23 00:00:00 | - | -
 | NDPU | 3-6 | 2004-04-01 00:00:00 | 9 | 47
 | NDPU | 3-6 | 2004-04-01 00:00:00 | 9 | 47
 | NDPU | 3-6 | 2004-05-04 00:00:00 | - | -
 | NDPU | 3-6 | 2004-05-22 00:00:00 | 9 | 42
 | NDPU | 3-6 | 2004-06-03 00:00:00 | 9 | 42
 | NDPU | 3-6 | 2004-07-25 00:00:00 | 10 | 40
 | NDPU | 3-6 | 2004-09-14 00:00:00 | - | -
 | NDPU | 3-6 | 2004-10-13 00:00:00 | 9 | 32
 | NDPU | 3-6 | 2004-10-15 00:00:00 | 9 | 32
 | NDPU | 3-6 | 2004-12-25 00:00:00 | - | -
 | NDPU | 3-6 | 2005-01-08 00:00:00 | 11 | 48
 | NDPU | 3-6 | 2005-02-05 00:00:00 | - | -
 | NDPU | 3-6 | 2005-02-26 00:00:00 | 12 | 46
 | NDPU | 3-6 | 2005-04-10 00:00:00 | - | -
 | NDPU | 3-6 | 2005-04-16 00:00:00 | 11 | 30
 | NDPU | 3-6 | 2005-05-06 00:00:00 | 11 | 36
 | NDPU | 3-6 | 2005-06-25 00:00:00 | - | -
 | NDPU | 3-6 | 2005-06-30 00:00:00 | - | -
 | NDPU | 3-6 | 2005-07-01 00:00:00 | 10 | 28
 | NDPU | 3-6 | 2005-07-08 00:00:00 | - | -
 | NDPU | 3-6 | 2005-08-03 00:00:00 | - | -
 | NDPU | 3-6 | 2005-08-21 00:00:00 | - | -
 | NDPU | 3-6 | 2005-10-15 00:00:00 | - | -
 | NDPU | 3-6 | 2005-12-01 00:00:00 | - | -
 | NDPU | 3-6 | 2006-01-12 00:00:00 | 12 | 622
 | NDPU | 3-6 | 2006-01-31 00:00:00 | 6 | 101
 | NDPU | 3-6 | 2006-02-15 00:00:00 | - | -
 | NDPU | 3-6 | 2006-02-16 00:00:00 | 5 | 9
 | NDPU | 3-6 | 2006-03-16 00:00:00 | - | -
 | NDPU | 3-6 | 2006-04-16 00:00:00 | 7 | 38
 | NDPU | 3-6 | 2006-04-23 00:00:00 | - | -
 | NDPU | 3-6 | 2006-04-29 00:00:00 | - | -
 | NDPU | 3-6 | 2006-05-05 00:00:00 | 7 | 57
 | NDPU | 3-6 | 2006-05-14 00:00:00 | 7 | 57
 | NDPU | 3-6 | 2006-06-29 00:00:00 | - | -
 | NDPU | 3-6 | 2006-06-30 00:00:00 | - | -
 | NDPU | 3-6 | 2006-07-06 00:00:00 | - | -
 | NDPU | 3-6 | 2006-07-19 00:00:00 | - | -
 | NDPU | 3-6 | 2006-07-26 00:00:00 | - | -
 | NDPU | 3-6 | 2006-07-27 00:00:00 | - | -
 | NDPU | 3-6 | 2006-07-27 00:00:00 | - | -
 | NDPU | 3-6 | 2006-07-29 00:00:00 | - | -
 | NDPU | 3-6 | 2006-07-30 00:00:00 | - | -
 | NDPU | 3-6 | 2006-08-09 00:00:00 | 11 | 283
 | NDPU | 3-6 | 2006-08-09 00:00:00 | - | -
 | NDPU | 3-6 | 2006-08-11 00:00:00 | - | -
 | NDPU | 3-6 | 2006-08-15 00:00:00 | - | -
 | NDPU | 3-6 | 2006-08-16 00:00:00 | 34 | 1118
 | NDPU | 3-6 | 2006-08-16 00:00:00 | 31 | 993
 | NDPU | 3-6 | 2006-08-17 00:00:00 | - | -
 | NDPU | 3-6 | 2006-08-18 00:00:00 | - | -
 | NDPU | 3-6 | 2006-08-23 00:00:00 | - | -
 | NDPU | 3-6 | 2006-08-25 00:00:00 | 14 | 968
 | NDPU | 3-6 | 2006-08-30 00:00:00 | 13 | 765
 | NDPU | 3-6 | 2006-08-30 00:00:00 | 12 | 876
 | NDPU | 3-6 | 2006-09-04 00:00:00 | 13 | 839
 | NDPU | 3-6 | 2006-09-13 00:00:00 | - | -
 | NDPU | 3-6 | 2006-09-14 00:00:00 | 12 | 765
 | NDPU | 3-6 | 2006-10-02 00:00:00 | 21 | 675
 | NDPU | 3-6 | 2006-10-03 00:00:00 | - | -
 | NDPU | 3-6 | 2006-10-05 00:00:00 | - | -
 | NDPU | 3-6 | 2006-10-06 00:00:00 | - | -
 | NDPU | 3-6 | 2006-10-11 00:00:00 | - | -
 | NDPU | 3-6 | 2006-11-01 00:00:00 | - | -
 | NDPU | 3-6 | 2006-11-18 00:00:00 | - | -
 | NDPU | 3-6 | 2006-11-22 00:00:00 | - | -
 | NDPU | 3-6 | 2006-11-26 00:00:00 | 11 | 744
 | NDPU | 3-6 | 2006-12-10 00:00:00 | 12 | 634
 | NDPU | 3-6 | 2007-02-01 00:00:00 | - | -
 | NDPU | 3-6 | 2007-02-02 00:00:00 | - | -
 | NDPU | 3-6 | 2007-02-03 00:00:00 | - | -
 | NDPU | 3-6 | 2007-02-13 00:00:00 | 6 | 593
 | NDPU | 3-6 | 2007-05-24 00:00:00 | 7 | 328
 | NDPU | 3-6 | 2007-06-12 00:00:00 | 15 | 426
 | NDPU | 3-6 | 2007-06-19 00:00:00 | 14 | 392
 | NDPU | 3-6 | 2007-07-18 00:00:00 | - | -
 | NDPU | 3-6 | 2007-07-26 00:00:00 | - | -
 | NDPU | 3-6 | 2007-08-17 00:00:00 | - | -
 | NDPU | 3-6 | 2007-08-25 00:00:00 | - | -
 | NDPU | 3-6 | 2007-09-08 00:00:00 | 14 | 338
 | NDPU | 3-6 | 2007-10-11 00:00:00 | - | -
 | NDPU | 3-6 | 2007-10-19 00:00:00 | 13 | 30
 | NDPU | 3-6 | 2007-10-22 00:00:00 | - | -
 | NDPU | 3-6 | 2007-11-07 00:00:00 | - | -
 | NDPU | 3-6 | 2007-11-11 00:00:00 | 14 | 292
 | NDPU | 3-6 | 2007-12-01 00:00:00 | - | -
 | NDPU | 3-6 | 2007-12-02 00:00:00 | 9 | 297
 | NDPU | 3-6 | 2007-12-02 00:00:00 | - | -
 | NDPU | 3-6 | 2007-12-09 00:00:00 | 9 | 20
 | NDPU | 3-6 | 2007-12-22 00:00:00 | 11 | 307
 | NDPU | 3-6 | 2007-12-27 00:00:00 | - | -
 | NDPU | 3-6 | 2008-01-18 00:00:00 | 12 | 313
 | NDPU | 3-6 | 2008-01-27 00:00:00 | - | -
 | NDPU | 3-6 | 2008-02-12 00:00:00 | 13 | 322
 | NDPU | 3-6 | 2008-03-16 00:00:00 | 14 | 332
 | NDPU | 3-6 | 2008-03-23 00:00:00 | - | -
 | NDPU | 3-6 | 2008-04-05 00:00:00 | - | -
 | NDPU | 3-6 | 2008-05-10 00:00:00 | 14 | 343
 | NDPU | 3-6 | 2008-06-21 00:00:00 | 13 | 335
 | NDPU | 3-6 | 2008-07-16 00:00:00 | 14 | 344
 | NDPU | 3-6 | 2008-08-12 00:00:00 | 13 | 371
 | NDPU | 3-6 | 2008-08-17 00:00:00 | - | -
 | NDPU | 3-6 | 2008-10-25 00:00:00 | 48 | 197
 | NDPU | 3-6 | 2008-11-26 00:00:00 | - | -
 | NDPU | 3-6 | 2008-11-29 00:00:00 | - | -
 | NDPU | 3-6 | 2008-12-04 00:00:00 | - | -
 | NDPU | 3-6 | 2008-12-06 00:00:00 | 36 | 205
 | NDPU | 3-6 | 2008-12-06 00:00:00 | - | -
 | NDPU | 3-6 | 2008-12-13 00:00:00 | - | -
 | NDPU | 3-6 | 2009-01-07 00:00:00 | - | -
 | NDPU | 3-6 | 2009-01-08 00:00:00 | - | -
 | NDPU | 3-6 | 2009-02-05 00:00:00 | 19 | 281
 | NDPU | 3-6 | 2009-03-05 00:00:00 | - | -
 | NDPU | 3-6 | 2009-03-10 00:00:00 | 7 | 93
 | NDPU | 3-6 | 2009-03-10 00:00:00 | - | -
 | NDPU | 3-6 | 2009-03-13 00:00:00 | - | -
 | NDPU | 3-6 | 2009-03-21 00:00:00 | - | -
 | NDPU | 3-6 | 2009-03-25 00:00:00 | - | -
 | NDPU | 3-6 | 2009-03-26 00:00:00 | 30 | 130
 | NDPU | 3-6 | 2009-03-27 00:00:00 | - | -
 | NDPU | 3-6 | 2009-03-28 00:00:00 | - | -
 | NDPU | 3-6 | 2009-04-01 00:00:00 | - | -
 | NDPU | 3-6 | 2009-04-02 00:00:00 | 26 | 103
 | NDPU | 3-6 | 2009-04-03 00:00:00 | - | -
 | NDPU | 3-6 | 2009-04-04 00:00:00 | 13 | 64
 | NDPU | 3-6 | 2009-04-05 00:00:00 | - | -
 | NDPU | 3-6 | 2009-04-11 00:00:00 | 15 | 111
 | NDPU | 3-6 | 2009-05-07 00:00:00 | 13 | 101
 | NDPU | 3-6 | 2009-05-22 00:00:00 | - | -
 | NDPU | 3-6 | 2009-06-06 00:00:00 | - | -
 | NDPU | 3-6 | 2009-06-08 00:00:00 | 5 | 30
 | NDPU | 3-6 | 2009-07-19 00:00:00 | 12 | 65
 | NDPU | 3-6 | 2009-07-19 00:00:00 | - | -
 | NDPU | 3-6 | 2009-07-27 00:00:00 | 9 | 65
 | NDPU | 3-6 | 2009-08-08 00:00:00 | 11 | 80
 | NDPU | 3-6 | 2009-08-10 00:00:00 | 11 | 80
 | NDPU | 3-6 | 2009-09-06 00:00:00 | - | -
 | NDPU | 3-6 | 2009-09-19 00:00:00 | 12 | 65
 | NDPU | 3-6 | 2009-10-02 00:00:00 | 13 | 74
 | NDPU | 3-6 | 2009-10-22 00:00:00 | 11 | 60
 | NDPU | 3-6 | 2009-11-08 00:00:00 | - | -
 | NDPU | 3-6 | 2009-11-22 00:00:00 | 12 | 59
 | NDPU | 3-6 | 2010-01-25 00:00:00 | 10 | 53
 | NDPU | 3-6 | 2010-03-09 00:00:00 | - | -
 | NDPU | 3-6 | 2010-03-15 00:00:00 | 8 | 48
 | NDPU | 3-6 | 2010-04-11 00:00:00 | 11 | 46
 | NDPU | 3-6 | 2010-05-14 00:00:00 | 10 | 48
 | NDPU | 3-6 | 2010-05-15 00:00:00 | 10 | 48
 | NDPU | 3-6 | 2010-06-08 00:00:00 | 8 | 44
 | NDPU | 3-6 | 2010-07-14 00:00:00 | 7 | 35
 | NDPU | 3-6 | 2010-09-11 00:00:00 | 8 | 48
 | NDPU | 3-6 | 2010-10-07 00:00:00 | - | -
 | NDPU | 3-6 | 2010-11-07 00:00:00 | 7 | 37
 | NDPU | 3-6 | 2010-12-08 00:00:00 | 6 | 31
 | NDPU | 3-6 | 2011-01-13 00:00:00 | 5 | 30
 | NDPU | 3-6 | 2011-01-19 00:00:00 | - | -
 | NDPU | 3-6 | 2011-01-30 00:00:00 | - | -
 | NDPU | 3-6 | 2011-04-21 00:00:00 | - | -
 | NDPU | 3-6 | 2011-05-08 00:00:00 | - | -
 | NDPU | 3-6 | 2011-06-22 00:00:00 | 8 | 54
 | NDPU | 3-6 | 2011-07-14 00:00:00 | 5 | 40
 | NDPU | 3-6 | 2011-08-10 00:00:00 | 5 | 28
 | NDPU | 3-6 | 2011-08-11 00:00:00 | - | -
 | NDPU | 3-6 | 2011-08-16 00:00:00 | 6 | 37
 | NDPU | 3-6 | 2011-09-29 00:00:00 | 7 | 34
 | NDPU | 3-6 | 2011-11-05 00:00:00 | - | -
 | NDPU | 3-6 | 2011-11-05 00:00:00 | - | -
 | NDPU | 3-6 | 2011-11-22 00:00:00 | 5 | 33
 | NDPU | 3-6 | 2011-12-01 00:00:00 | 5 | 33
 | NDPU | 3-6 | 2012-03-24 00:00:00 | 5 | 32
 | NDPU | 3-6 | 2012-04-10 00:00:00 | 6 | 38
 | NDPU | 3-6 | 2012-04-10 00:00:00 | 6 | 35
 | NDPU | 3-6 | 2012-09-08 00:00:00 | 5 | 29
 | NDPU | 3-6 | 2012-10-04 00:00:00 | 5 | 33
 | NDPU | 3-6 | 2013-01-01 00:00:00 | 5 | 21
 | NDPU | 3-6 | 2013-02-01 00:00:00 | 4 | 16
 | NDPU | 3-6 | 2013-02-15 00:00:00 | 3 | 12
 | NDPU | 3-6 | 2013-05-16 00:00:00 | 4 | 18
 | NDPU | 3-6 | 2013-06-30 00:00:00 | 4 | 18
 | NDPU | 3-6 | 2013-07-14 00:00:00 | 5 | 23