Assuming the spelled out month name is in cell A1, put the numbers 1, 2, 3,...,27,28 in cells B1:AC1, then put these formulas in the indicated cells...
AD1: =IF(MONTH(0+(28&A1&YEAR(NOW())))=MONTH(1+(28&A1&YEAR(NOW()))),29,"")
AE1: =IF(AD1="","",AD1+1)
AF1: =IF(ISNUMBER(SEARCH(LEFT(A1,3),"Jan Mar May Jul Aug Oct Dec")),AE1+1,"")