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

NickHK

"Jim9980" wrote in
message ...

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