Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am able to have info arranged in column 1 according to the date. Example,
Cell 1A = 1st day of the month, Cell 2A = 2nd day of the month. How do I make column 2 equal February, column 3 equal march etc. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
It depends whether you want a date or text.
If you want Text, Enter Jan in A1, then use the fill handle to drag it. Excel will fill in the months automatically. If you want dates, enter any date in January in A1. Format as mmm. In A2, enter =date(year(a1),month(a1)+1,day(a1)) copy down as needed. Regards, Fred "sunderhill20" wrote in message ... I am able to have info arranged in column 1 according to the date. Example, Cell 1A = 1st day of the month, Cell 2A = 2nd day of the month. How do I make column 2 equal February, column 3 equal march etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
function to fill all days of month to end of month | Excel Worksheet Functions | |||
function to fill all days of month to end of month | Excel Worksheet Functions | |||
When using MONTH function on Blank Cell!! Returns Month=Jan! | Excel Discussion (Misc queries) | |||
=Month function in Excel gives incorrect month | New Users to Excel | |||
Using the Month function to sum another column | Excel Worksheet Functions |