Thread: How create 365 labels for 2009? Example: Monday, Jan. 4, 2009
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JBeaucaire JBeaucaire is offline
external usenet poster
  
Posts: 1
Default How create 365 labels for 2009? Example: Monday, Jan. 4, 2009

I cell A1, enter 1/4/2009.

Press CTRL+1 to format the cell, select DATE - Type: *Wednesday,
March14, 2001 - click OK.

Copy that cell down to B1.

In B1, change the cell to read =A1+1.

Copy down 363 more cells.

Do your MailMerge to Word.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=44585

Reply With QuoteReply With Quote