Automatic Date
Thanks guys.
-----Original Message-----
Michael,
Try this -
In A1 enter 1/1/00
in cell B1 enter =DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
drag the formula across as far as you want, e.g. to
December.
Then format all of these cells using - Format, Cells,
Number Tab, Custom,
Select "mmmm"
Hope that's what you're after
regards,
John
"Michael" wrote in message
...
Hi all,
Is it possible to have a cell say "b1" read from a
cell "A1" and automatically change to the following
month.
So If say "A1" was January, I want "b1" to be february
but
I need it to be calcuated by a function. To date I have
just been adding 31 days to each cell in column a which
has worked. i.e "b1" formula reads = a1+31 etc... I am
using David McRichies "Insertandfillformulas" but for
some
reason it can't read column A this formula and things
aren't working !.
Thanks for your help
Regards,
Michael
.
|