View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld
 
Posts: n/a
Default Auto input days of week

On Wed, 4 Jan 2006 14:50:55 -0600, brom0910
wrote:


Hi, I'm looking to set up a spreadsheet where users enter new months
date in cell A1, I have worked out how to auto input dates down the
rest of column A but need to fill in days of week in column B. I'm
trying to automate process as not all users proficient with excel. It
needs to work for any month. Any help would be much appriciated.


In column B:

B2: =A2

Format/Cells/Number/Custom Type: dddd


--ron