Returning the day of the week

[safarijoe2000]

Hello,

I was wondering if you could tell me how to return the day of the week on an Excel 97 spreadsheet.

For example I have a column with the actual dates for the next few months, as in:
30/06/05
01/07/05
...........etc

I would like to see something like this:
Thursday 30/06
Friday 01/07
...........etc

Any help would be greatly appreciate it.

Thanks

 

[GlennUK]

Why don't you just format them as
dddd dd/mm

using Custom Format. Menu command Format/Cells/Number/Custom, and type the format into the input box.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[SkipVought]

Hi,

Just a simple FORMAT...
[tt]
dddd dd/mm
[/tt]
Format/Cell/Numeric Tab -- Custom

Skip,
[sub]
[red]Be advised:[/red]To be safe on the FOURTH, don't take a FIFTH on the THIRD, or...
You might not come FORTH on the FIFTH! [/sub]

 

[GlennUK]

SNAP

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[SkipVought]

UR speedy Gonzalez! ;-)

Skip,
[sub]
[red]Be advised:[/red]To be safe on the FOURTH, don't take a FIFTH on the THIRD, or...
You might not come FORTH on the FIFTH! [/sub]

 

[GlennUK]

Arriba! Arriba! Andale! Andale! YEEHAH!"

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.