Ken,

Assume your row6 entry starts at cell A6, enter a direct reference to cell
V1. For example in cell A6 enter:

=V1

then, go to custom formatting in cell A6 and use the "mmmm" format. You
should get the complete spelling of "January".

To get February, go to cell B6 and enter

=A6 + 28

then, go to custom formatting in cell B6 and use the "mmmm" format. You
should get the complete spelling of "February".

The same logic applies for the rest of the months.

----
Regards,
John Mansfield
http://www.pdbook.com


"Ken" wrote:

Excel 2000 ... I have a date (01/01/05) in cell V1.

In 12 other cells I would like to put formula that will
give me months of year January, February, March (complete
spelling) based on Date entered in Cell V1.

Row 6 ... January ... February ... March
Row 12 ... April ... May ... June
Row 18 ... July ... August ... September
Row 24 ... October ... November ... December

I have 4 rows by 3 columns of date Fields that I wish to
fill in using a formula ... Thanks ... Kha