Formating Day of the week
Donna,
Hi.
How about =left(text(a1,"dddd"),3)
which would yeield Fri
if a1=today()
3 would be the # of chars to display
I'm sure there are other ways.
Not sure if this is what you wanted either.
"Donna" wrote:
I have a monthly template that I use for scheduling. Once I change the month,
I have the worksheet formulated to change the dates. I then used a lookup
table to add what the day of week is. I want to show the abbreviation instead
of the whole word. I tried adding text(be,"ddd") to the formula but could not
get it to work. Any suggestions.
Thank you!
--
Donna
|