Mick,

In Excel, go to Insert/function and under Function catagoty, highlight
"Date & time. Under Function name, highlight "Date". This will give you -
year, month and day.

Hope that is what you sare looking for.

Lew Russakov
Huntington Beach, CA 92648
**************************

Date:    Mon, 4 Aug 2003 09:41:11 +0100
From:    Mick Fitzpatrick <[log in to unmask]>
Subject: Excel 97 insert date and day

Hello

In one of my Excel 97 workbooks I have the date displayed for each entry.
I
would also like to display the day ... and so far I have been typing it
in.
I'd like to try and 'automate' it as I make many entries to the sheet per
day and it would save time. I normally type in the date like 02 SEP 03,
then
Excel diplays it as 02-Sep-03 ... if it could display the relevant day as
well this would be a real bonus for me.

Is this possible?

TIA ... Mick

                         PCSOFT's List Owner's:
                      Bob Wright<[log in to unmask]>
                       Drew Dunn<[log in to unmask]>