Shock Horror

J

Jim Bunton

Went into a cell and typed
=Format(avalidDate,"ddd")

expecting Mon or Tue or . . . .

and it said ERROR!

how then do I display a date as the day!!!
Not an option that's displaying in the format date dialogue!

I can hardly believe it

almost as bad a s the day many years ago when I typed A1 + A2 at Lotus 123
and it failed because I'd put spaces each side of the + sign!

Jim Bunton
 
D

Dave Peterson

You could also give the cell a custom format:

Format|cells|Number tab
custom category
ddd

or
mm/dd/yyyy ddd

or (I like this one)
mm/dd/yyyy* dddd
 
R

Ron Rosenfeld

Went into a cell and typed
=Format(avalidDate,"ddd")

expecting Mon or Tue or . . . .

and it said ERROR!
Click to expand...

Are you sure it said ERROR! ?

When I do that it says #NAME? since there is no FORMAT worksheet function in my
version of Excel.

how then do I display a date as the day!!!
Click to expand...

Did you try the TEXT worksheet function?

=TEXT(avalidDate,"ddd")


--ron
 
Top