Remember Me?

#1
October 29th 04, 09:05 PM
 Chip1035 Posts: n/a
Days of the Month

Here is what I am trying to do, create a sheet where the dates automaticly
come up once I enter in the month and year in one of the cells. Something to
look like this:

A
1 09/2005
2 09/01/2005
3 09/02/2005
4 09/03/2005
5 09/04/2005
6 09/05/2005

If I change A1 to 10/2005, the dates change with it. I had a formula for it
but when I entered February, March would always come up. I know about the
Edit - Fill - Series option but I want a more automatic approach. Thanks for
--
-Chip
=)

#2
October 29th 04, 09:35 PM
 Jason Morin Posts: n/a

In A2 put:

=A1

and in A3 put:

=IF(A2="","",IF(MONTH(A2+1)<MONTH(A\$1),"",A2+1))

and fill down to A32.

HTH
Jason
Atlanta, GA

-----Original Message-----
Here is what I am trying to do, create a sheet where the

dates automaticly
come up once I enter in the month and year in one of the

cells. Something to
look like this:

A
1 09/2005
2 09/01/2005
3 09/02/2005
4 09/03/2005
5 09/04/2005
6 09/05/2005

If I change A1 to 10/2005, the dates change with it. I

but when I entered February, March would always come

Edit - Fill - Series option but I want a more automatic

approach. Thanks for
--
-Chip
=)
.

#3
October 29th 04, 09:47 PM
 AndreasN Posts: n/a

Good evening Chip,
Can you write in a new message the formula you used, please?

Ο "Chip1035" έγραψε στο μήνυμα
...
Here is what I am trying to do, create a sheet where the dates automaticly
come up once I enter in the month and year in one of the cells. Something
to
look like this:

A
1 09/2005
2 09/01/2005
3 09/02/2005
4 09/03/2005
5 09/04/2005
6 09/05/2005

If I change A1 to 10/2005, the dates change with it. I had a formula for
it
but when I entered February, March would always come up. I know about the
Edit - Fill - Series option but I want a more automatic approach. Thanks
for
--
-Chip
=)

#4
October 30th 04, 03:58 AM
 Chip1035 Posts: n/a

THANK YOU!!! It worked!

"Jason Morin" wrote:

In A2 put:

=A1

and in A3 put:

=IF(A2="","",IF(MONTH(A2+1)<MONTH(A\$1),"",A2+1))

and fill down to A32.

HTH
Jason
Atlanta, GA

-----Original Message-----
Here is what I am trying to do, create a sheet where the

dates automaticly
come up once I enter in the month and year in one of the

cells. Something to
look like this:

A
1 09/2005
2 09/01/2005
3 09/02/2005
4 09/03/2005
5 09/04/2005
6 09/05/2005

If I change A1 to 10/2005, the dates change with it. I

but when I entered February, March would always come

Edit - Fill - Series option but I want a more automatic

approach. Thanks for
--
-Chip
=)
.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Steve Excel Discussion (Misc queries) 2 January 21st 05 10:41 PM PM Excel Discussion (Misc queries) 2 January 19th 05 04:07 PM Charles Excel Discussion (Misc queries) 4 January 18th 05 05:07 PM Mikeyh133 Excel Discussion (Misc queries) 2 December 31st 04 08:53 PM mpetersen Excel Discussion (Misc queries) 3 December 16th 04 03:41 PM

All times are GMT +1. The time now is 11:19 PM.