Thread: Date?
View Single Post
  #1   Report Post  
Ken
 
Posts: n/a
Default Date?

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