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
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
any help, in advance.
--
-Chip
=)
.
|