I should have looked at the template before posting (I would have realized there is a column to enter dates, not just a cell), but here is the formula, just a simple VLOOKUP is all that is needed. Assuming the calendar range begins with C5, and the dates will be entered in A1:A30...
=VLOOKUP(C5,$A$1:$A$40,1,0)
|