Spreadsheet: 787173d1657653911-excel-formula-not-carrying-down-correctly-using-wrong-intervals-of-rows-sample-sheet-formula
Sheet: Option 1 Summary by PM

PM | Month | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th | 29th | 30th | 31st | Mid Month Difference | Month Difference | # of Days in Month | 1st Weekday of Month | Middle Day Date | 1st Weekday Reference | Middle Month Reference | End of Month Reference
A | January | 0 | 0 | 47829.41 | 47829.41 | 47829.41 | 47829.41 | 47829.41 | 0 | 0 | 47829.41 | 47829.41 | 39755 | 39755 | 39755 | 0 | 0 | 39755 | 39755 | 39755 | 39755 | 46935 | 0 | 0 | 46935 | 46935 | 46935 | 46935 | 66220.71 | 0 | 0 | 64320.71 | 0.6179 | 0.3448 | 31 | 3 | 14 | 47829.41 | 39755 | 64320.71
 | February | 104502.35 | 17175 | 17175 | 17175 | 0 | 0 | 17175 | 11775 | 11775 | 11775 | 11775 | 0 | 0 | 11775 | 11775 | 11775 | 11775 | 11775 | 0 | 0 | 11775 | 11775 | 11775 | 11775 | 9075 | 0 | 0 | 9075 | 0 | 0 | 0 | -0.2293 | -0.4716 | 28 | 1 | 14 | 17175 | 11775 | 9075
 | March | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 31 | 1 | 15 | 0 | 0 | 0
 | April | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 30 | 1 | 15 | 0 | 0 | 0
 | May | 0 | 19521.43 | 19521.43 | 0 | 0 | 30443.06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | -1 | 31 | 2 | 16 | 19521.43 | 0 | 0
 | June | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 30 | 1 | 15 | 0 | 0 | 0
 | July | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 31 | 1 | 15 | 0 | 0 | 0
 | August | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 31 | 1 | 15 | 0 | 0 | 0
 | September | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 30 | 1 | 15 | 0 | 0 | 0
 | October | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 31 | 3 | 14 | 0 | 0 | 0
 | November | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 30 | 1 | 15 | 0 | 0 | 0
 | December | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 31 | 1 | 15 | 0 | 0 | 0
B | January | 0 | 0 | 93027.45 | 93027.45 | 71062.41 | 71062.41 | 69517.97 | 0 | 0 | 58011.86 | 58011.86 | 58011.86 | 58011.86 | 58011.86 | 0 | 0 | 58011.86 | 58011.86 | 58011.86 | 58011.86 | 58011.86 | 0 | 0 | 58280.61 | 57245.66 | 57245.66 | 56178.54 | 55756.58 | 0 | 0 | 55756.58 | -0.0389 | -0.4006 | 31 | 3 | 14 | 93027.45 | 58011.86 | 55756.58
 | February | 125987.79 | 125987.79 | 125987.79 | 125987.79 | 0 | 0 | 125987.79 | 74109.35 | 74603.38 | 74603.38 | 74603.38 | 0 | 0 | 74603.38 | 68565.56 | 68565.56 | 66359.55 | 66529.55 | 0 | 0 | 63811.63 | 63811.63 | 63811.63 | 63534.96 | 63412.65 | 0 | 0 | 63412.65 | 0 | 0 | 0 | -0.15 | -0.4967 | 28 | 1 | 14 | 125987.79 | 74603.38 | 63412.65
 | March | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 31 | 1 | 15 | 0 | 0 | 0
 | April | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 30 | 1 | 15 | 0 | 0 | 0
 | May | 0 | 88200.08 | 88200.08 | 88200.08 | 137068.52 | 95666.35 | 0 | 0 | 88219.92 | 88219.92 | 67583.79 | 67583.79 | 67583.79 | 0 | 0 | 88219.92 | 88219.92 | 67583.79 | 67583.79 | 67583.79 | 0 | 0 | 74685.47 | 74685.47 | 78715.17 | 77698.28 | 76507.46 | 0 | 0 | 76507.46 | 76507.46 | -0.1328 | -0.1326 | 31 | 2 | 16 | 88200.08 | 88219.92 | 76507.46
 | June | 112230.85 | 112230.85 | 112230.85 | 0 | 0 | 112230.85 | 112230.85 | 112230.85 | 112230.85 | 97615.02 | 0 | 0 | 90715.32 | 90715.32 | 94875.38 | 88629.62 | 92201.05 | 0 | 0 | 92201.05 | 92201.05 | 110801.09 | 110801.09 | 110801.09 | 0 | 0 | 122509.99 | 113570.22 | 114542.2 | 114542.2 | 0 | 0.2073 | 0.0206 | 30 | 1 | 15 | 112230.85 | 94875.38 | 114542.2
 | July | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 31 | 1 | 15 | 0 | 0 | 0
 | August | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 31 | 1 | 15 | 0 | 0 | 0
 | September | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 30 | 1 | 15 | 0 | 0 | 0
 | October | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 31 | 3 | 14 | 0 | 0 | 0
 | November | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 30 | 1 | 15 | 0 | 0 | 0
 | December | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 31 | 1 | 15 | 0 | 0 | 0
C | January | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 31 | 3 | 14 | 0 | 0 | 0
 | February | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 28 | 1 | 14 | 0 | 0 | 0
 | March | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 31 | 1 | 15 | 0 | 0 | 0
 | April | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 30 | 1 | 15 | 0 | 0 | 0
 | May | 0 | 73041.25 | 73041.25 | 73041.25 | 73041.25 | 88041.96 | 0 | 0 | 79360.71 | 79360.71 | 79360.71 | 79360.71 | 79360.71 | 0 | 0 | 79360.71 | 79360.71 | 79360.71 | 79360.71 | 79360.71 | 0 | 0 | 82575 | 82574.75 | 82574.75 | 82574.75 | 96810.73 | 0 | 0 | 96810.73 | 96810.73 | 0.2199 | 0.3254 | 31 | 2 | 16 | 73041.25 | 79360.71 | 96810.73
 | June | 79752.93 | 44329.46 | 44329.46 | 0 | 0 | 53583.92 | 53583.92 | 53583.92 | 46422.14 | 46422.14 | 0 | 0 | 46722.14 | 52420.35 | 52420.35 | 52420.35 | 22900.72 | 0 | 0 | 22900.72 | 22900.72 | 27668.58 | 27668.58 | 32561.88 | 0 | 0 | 24794.46 | 24794.46 | 26510.39 | 26510.39 | 0 | -0.4943 | -0.402 | 30 | 1 | 15 | 44329.46 | 52420.35 | 26510.39
 | July | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 31 | 1 | 15 | 0 | 0 | 0
 | August | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 31 | 1 | 15 | 0 | 0 | 0
 | September | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 30 | 1 | 15 | 0 | 0 | 0
 | October | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 31 | 3 | 14 | 0 | 0 | 0
 | November | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 30 | 1 | 15 | 0 | 0 | 0
 | December | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 31 | 1 | 15 | 0 | 0 | 0
D | January | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | N/A | N/A | 31 | 3 | 14 | - | - | -
 | February | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | N/A | N/A | 28 | 1 | 14 | - | - | -
 | March | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | N/A | N/A | 31 | 1 | 15 | - | - | -
 | April | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | N/A | N/A | 30 | 1 | 15 | - | - | -
 | May | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | 0.2199 | 0.3254 | 31 | 2 | 16 | - | - | -
 | June | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6472.55 | 6472.55 | 7324.25 | 0 | 0 | 7324.25 | 7324.25 | 7324.25 | 7324.25 | 7324.25 | 0 | 0 | 7324.25 | 10223.71 | 10223.71 | 10223.71 | 19476.7 | 0 | 0 | 20571.99 | 20571.99 | 20571.99 | 20571.99 | 0 | -0.4943 | -0.402 | 30 | 1 | 15 | 0 | 7324.25 | 20571.99
 | July | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 31 | 1 | 15 | 0 | 0 | 0
 | August | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 31 | 1 | 15 | 0 | 0 | 0
 | September | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 30 | 1 | 15 | 0 | 0 | 0
 | October | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 31 | 3 | 14 | 0 | 0 | 0
 | November | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 30 | 1 | 15 | 0 | 0 | 0
 | December | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | N/A | N/A | 31 | 1 | 15 | 0 | 0 | 0