Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Two points.
1. In the example given below, you need to add 31, not 28 days to get to February. 2. The method will only work for non leap years. For a leap year, you would have to add 29 days to February to get March. 3. I assume the date in V1 will not necessarily be January or 1st of the month so this static method will not work. As an alternative, use =EDATE(V1,x) where x is the number of months you want to add. This function requires the Analysis Toolpak (ATP) to be installed and activated in Excel (Thanks to Max for his pointer). Ian "John Mansfield" wrote in message ... 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 |
#4
|
|||
|
|||
-----Original Message----- Two points. 1. In the example given below, you need to add 31, not 28 days to get to February. 2. The method will only work for non leap years. For a leap year, you would have to add 29 days to February to get March. 3. I assume the date in V1 will not necessarily be January or 1st of the month so this static method will not work. As an alternative, use =EDATE(V1,x) where x is the number of months you want to add. This function requires the Analysis Toolpak (ATP) to be installed and activated in Excel (Thanks to Max for his pointer). Ian "John Mansfield" wrote in message ... 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions |