Retain Cell Results While Removing Cell Formulas

Firstly, yes, I am using Microsoft Excel. Pardon me please for neglecting to mention that. Please allow me to expand on my problem.

I entered a date in the first cell (8/1/2005). In the cell below that I entered =A1+1. Then, I copied the formula from the second cell down for a whole year. Is it possible to then remove the formula from each of these cells yet still leave the date that resulted from the formula?

I could not accomplish this with the first suggestion. Thank you for helping.

First an alternative. Put 8/1/2005 in A1. Then click and move cursor to the small black square in the bottom right corner (the 'handle') until it becomes a plus-sign. Then drag that down, and Excel will automatically increase the date by 1 day for each lower cell.

Then another alternative. Use Edit>Fill>Series. More info in http://vgupta.com/Products/Abstracts/Fill.pdf. You might need some experimenting, but it will work.

And, yes, my original suggestion works also. I just tried.
A1=date
A2=A1+1, dragged down to A35
Then select A1:A35, Edit>Copy, Edit>Paste Special, choose Values.

Choose one of these. And, of course, there's nothing really wrong with keeping the formulas in place, is there?

Kees

Your suggestions work now that I understand how to use them. Thank you.

At first I thought it would be easier to fill in the dates by copying the formula and pasting it to all the remaining cells for the year rather than entering a date manually into each of the 265 cells. Then, as I thought that I usually mess around with the look of a worksheet and I did not want the cell formulas to get screwed up if I moved them around or inserted blank rows ever week, etc. Maybe nothing to be overly concerned about but something I was curious about nontheless. Thenk you again for being a great help.