software

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.--
brom0910
------------------------------------------------------------------------
brom0910's Profile: www.excelforum.com/member.php...oamp;userid=27416
View this thread: www.excelforum.com/showthread...hreadid=498071Custom format Column B to:
ddd OR dddd
Then, in B1, enter
=A1
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================quot;brom0910quot; gt; wrote in
message ...
gt;
gt; Hi, I'm looking to set up a spreadsheet where users enter new months
gt; date in cell A1, I have worked out how to auto input dates down the
gt; rest of column A but need to fill in days of week in column B. I'm
gt; trying to automate process as not all users proficient with excel. It
gt; needs to work for any month. Any help would be much appriciated.
gt;
gt;
gt; --
gt; brom0910
gt; ------------------------------------------------------------------------
gt; brom0910's Profile:
www.excelforum.com/member.php...oamp;userid=27416
gt; View this thread: www.excelforum.com/showthread...hreadid=498071
gt;
How about something like this:

=TEXT(WEEKDAY(A3),quot;dddquot;) copied down
for all week days

or

=IF(AND(WEEKDAY(A3)gt;1,WEEKDAY(A3)lt;7),TEXT(WEEKDAY( A3),quot;dddquot;),quot;quot;)
week days only, no weekend days

or simply
=A3 with cells formatted as quot;dddquot;

HTH
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=498071If column A contains a calculated date that Excel recognizes as a date,
you can either...
1. Format the date cells in column A to show the day name as well as
the date, or
2. Add a formula to the cells in column B that simply reference column
A, then custom format that cell with quot;dddddquot; to show the day only in
that column.On Wed, 4 Jan 2006 14:50:55 -0600, brom0910
gt; wrote:

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

In column B:

B2: =A2

Format/Cells/Number/Custom Type: dddd--ron


Thanks guys for your info - tried them all amp; all worked fine. great
job..--
brom0910
------------------------------------------------------------------------
brom0910's Profile: www.excelforum.com/member.php...oamp;userid=27416
View this thread: www.excelforum.com/showthread...hreadid=498071