the second bit is at bottom of sheet you have the field where old chippy says enter start date
the numbers c47:n47 must match the number of days in month so change them
with the exception of february which needs this formula instead
=28+FLOOR(1/(B1-FLOOR(B1/4,1)*4+1),1)
Bookmarks