| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
help with dates please
Hi Dido22
First highlight the column you want those dates, then do a custom formatting like this mmm/yyyy. Paste this formula in the top cell and drag down. =DATE(2010,1+ROW(A1),0) My sample will start with Jan.2010, you just change the year and the number just after the year for the month and copy down. HTH John "dido22" wrote in message ... Can someone please help me generate a list of dates in a column. I just need month and year, so Jan 2010, Feb 2010, Mar 2010 .....etc. No days or dates. Thanks KK |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking computer dates (time) to spreadsheet dates that have formu | Excel Worksheet Functions | |||
| Stop dates from showing as numbers - when formated as dates | Excel Discussion (Misc queries) | |||
| compare 2 tables of dates to find the preceding dates | Excel Worksheet Functions | |||
| how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
| Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
![Cimjet[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
