Day / Date Formula
 

Is there an formula to automatically display the "day of the week" in cell A2
based on a date entered in cell A1? I have one now but it is very long and am
trying to shorten it.

NeilM

Day / Date Formula
 

Try this:
A2: =A1
FormatCellsNumber tab
Category: Custom
Type: ddd

Returns Mon, Tue, Wed, etc.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Neil M" wrote:

Is there an formula to automatically display the "day of the week" in cell A2
based on a date entered in cell A1? I have one now but it is very long and am
trying to shorten it.

NeilM

Day / Date Formula
 

=a1
and format it as: dddd

or just format A1 and give that a nice format:
mm/dd/yyyy* dddd



Neil M wrote:

Is there an formula to automatically display the "day of the week" in cell A2
based on a date entered in cell A1? I have one now but it is very long and am
trying to shorten it.

NeilM

--

Dave Peterson

Day / Date Formula
 

YES!!! I got this from a friend and as you can see, he took the long way

=IF((WEEKDAY(C6)=1),"Sunday",IF((WEEKDAY(C6)=2),"M onday",IF((WEEKDAY(C6)=3),"Tuesday",IF((WEEKDAY(C6 )=4),"Wednesday",IF((WEEKDAY(C6)
=5), "Thursday", IF((WEEKDAY(C6)=6), "Friday", IF((WEEKDAY(C6)=7),
"Saturday", "Incorrect")))))))

AHHHHHHHHHHHHHHHHHHHHH!!!

"Ron Coderre" wrote:

Try this:
A2: =A1
FormatCellsNumber tab
Category: Custom
Type: ddd

Returns Mon, Tue, Wed, etc.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Neil M" wrote:

Is there an formula to automatically display the "day of the week" in cell A2
based on a date entered in cell A1? I have one now but it is very long and am
trying to shorten it.

NeilM