Shock Horror

[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

 

[Don Guillett]

try =text

 

[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

 

[Ron Rosenfeld]

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

expecting Mon or Tue or . . . .

and it said ERROR!

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!!!

Did you try the TEXT worksheet function?

=TEXT(avalidDate,"ddd")


--ron