Page 1 of 1
Forum

Welcome to the Tweaking4All community forums!
When participating, please keep the Forum Rules in mind!

Topics for particular software or systems: Start your topic link with the name of the application or system.
For example “MacOS X – Your question“, or “MS Word – Your Tip or Trick“.

Please note that switching to another language when reading a post will not bring you to the same post, in Dutch, as there is no translation for that post!


Forums
Software
Windows Software
Excel - Create a li...
 
Share:
Notifications
Clear all

[Solved] Excel - Create a list of months ...

 
Windows Software
Last Post by Hans 11 years ago
1 Posts
1 Users
0 Reactions
1,341 Views
RSS
 Hans
(@hans)
Famed Member Admin
Joined: 12 years ago
Posts: 2859
Topic starter December 4, 2013 9:09 AM  

Making a list of months in excel as shown:

january 2014
februari 2014
march 2014
april 2014
mai 2014
june 2014

is done very easy:

make a field with contents: 1-1-2014

Increase each next field with 31 (!) example: =A1+31

choose format->cell,

select custom,

enter: mmmm jjjj


   
ReplyQuote
Forum Jump:
  Previous Topic
Next Topic  
Share: