Automatic Dates in Excel

Is it possible to create a spreadsheet with each day of the month marked i.e. Aug 1, 2, 3 etc. I thought that a formula would allow this so that I would not have to create and save a worksheet for each day of the month.

Sincerely,
Hoping…