Re: Auto input days of week

On Wed, 4 Jan 2006 14:50:55 -0600, brom0910
<brom0910.214ohm_1136408102.0295@xxxxxxxxxxxxxxxxxxxxx> 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
.

Relevant Pages

  • Auto input days of week
    ... 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 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • RE: What does this do?
    ... the rows.ccount returns the number of rows in the spreadsheet. ... ..endtravels up from this row to the first non-blank cell. ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • VBA - Last Cell In A Row
    ... How can I find the last cell in a row? ... I have this spreadsheet ... ajocius's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=17695 ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • X=1 Help!!!
    ... I have a spreadsheet where I have a cell NAMED "Free". ... prhrmk's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23934 ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: Excel 2007 high cpu usage, format cell, wrap text
    ... When she highlights the whole spreadsheet, and selects Format ... If the data cells are all contiguous, select any cell in the range and press ... This is necessary as Excel 2007 uses a lot of page memory. ...
    (microsoft.public.excel.misc)