Day / Date Formula

N

Neil M

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
 
R

Ron Coderre

Try this:
A2: =A1
Format>Cells>Number tab
Category: Custom
Type: ddd

Returns Mon, Tue, Wed, etc.

Does that help?

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

XL2002, WinXP-Pro
 
D

Dave Peterson

=a1
and format it as: dddd

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

Neil M

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),"Monday",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!!!
 
Top