How to generate dates for a month?

I am trying to use Excel to create a spreadsheet for each day of the month.
So for the first day, the formula i have in field A1 is:

=DATE(YEAR(NOW()),MONTH(NOW()),DAY(1))

The second day, the formula i have in field A2 is:

=DATE(YEAR(NOW()),MONTH(NOW()),DAY(1)+2)

How do i make it so that it can take the date from the previous and add 1 to it?

At the end i just want a simple formula which will automatically take the first of every month and add 1 day to it.
So eventually i will have something like this:

01/01/2006
02/01/2006
03/01/2006
....
...
31/01/2006

Many thanks in advance.

James

James,
Here's one solution, down the page at #13:
http://www.*****-blog.com/archives/2...ugly-formulas/

NickHK

"Jim9980" <Jim9980.21v20y_1137638701.7172@excelforum-nospam.com> wrote in
message news:Jim9980.21v20y_1137638701.7172@excelforum-nospam.com...
>
> I am trying to use Excel to create a spreadsheet for each day of the
> month.
> So for the first day, the formula i have in field A1 is:
>
> =DATE(YEAR(NOW()),MONTH(NOW()),DAY(1))
>
> The second day, the formula i have in field A2 is:
>
> =DATE(YEAR(NOW()),MONTH(NOW()),DAY(1)+2)
>
> How do i make it so that it can take the date from the previous and add
> 1 to it?
>
> At the end i just want a simple formula which will automatically take
> the first of every month and add 1 day to it.
> So eventually i will have something like this:
>
> 01/01/2006
> 02/01/2006
> 03/01/2006
> ...
> ..
> 31/01/2006
>
> Many thanks in advance.
>
> James
>
>
> --
> Jim9980
> ------------------------------------------------------------------------
> Jim9980's Profile:
http://www.excelforum.com/member.php...o&userid=30583
> View this thread: http://www.excelforum.com/showthread...hreadid=502759
>

in A1

=Today()
in A2
=A1+1
format both cells as Date
select A2 and drag fill down

--
Regards,
Tom Ogilvy

"Jim9980" <Jim9980.21v20y_1137638701.7172@excelforum-nospam.com> wrote in
message news:Jim9980.21v20y_1137638701.7172@excelforum-nospam.com...
>
> I am trying to use Excel to create a spreadsheet for each day of the
> month.
> So for the first day, the formula i have in field A1 is:
>
> =DATE(YEAR(NOW()),MONTH(NOW()),DAY(1))
>
> The second day, the formula i have in field A2 is:
>
> =DATE(YEAR(NOW()),MONTH(NOW()),DAY(1)+2)
>
> How do i make it so that it can take the date from the previous and add
> 1 to it?
>
> At the end i just want a simple formula which will automatically take
> the first of every month and add 1 day to it.
> So eventually i will have something like this:
>
> 01/01/2006
> 02/01/2006
> 03/01/2006
> ...
> ..
> 31/01/2006
>
> Many thanks in advance.
>
> James
>
>
> --
> Jim9980
> ------------------------------------------------------------------------
> Jim9980's Profile:
http://www.excelforum.com/member.php...o&userid=30583
> View this thread: http://www.excelforum.com/showthread...hreadid=502759
>

The forumla does not copy.