>Is there a way to have a cell, or cells, shaded depending on if the date in a cell is either the 1st or the 16th day of the month?

There's a conditional formatting option, but I'm not sure how to do it exactly like you want.