How to generate dates for a month?

J

Jim9980

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
 
T

Tom Ogilvy

in A1

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Date() function then adding 1 day to it. 3
Macro for Dates 5
Access Count dates within a Month 4
how to get month and year from date 3
days and months with heading zero from formula 2
Supressing a #VALUE! error returned? 3
Calculating occupational sick pay entitlement 0
Excel Vba to change displayed year automatically. 14

Top