Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,389
Default how do i set a column as a month in a function

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
function to fill all days of month to end of month Monique Excel Worksheet Functions 11 May 1st 06 07:39 PM
function to fill all days of month to end of month YaHootie Excel Worksheet Functions 10 May 1st 06 06:01 AM
When using MONTH function on Blank Cell!! Returns Month=Jan! mahou Excel Discussion (Misc queries) 6 January 9th 06 02:46 AM
=Month function in Excel gives incorrect month jbmx New Users to Excel 1 September 14th 05 07:58 PM
Using the Month function to sum another column Chris Excel Worksheet Functions 11 October 30th 04 08:49 AM


All times are GMT +1. The time now is 11:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"