Hi again, cheers biff, but it says 09 July 08 is a Monday!
:)

"T. Valko" wrote in message
...
niether approach works
I need A1,A2... to reflect the actual day name of the date in Col B

Well, you didn't say that column B *already* has the date! <g

Enter this formula in A1 and copy down as needed:

=TEXT(B1,"ddd") for the short day name like Mon

=TEXT(B1,"dddd") for the long day name like Monday

--
Biff
Microsoft Excel MVP


"Mathew P Bennett" wrote in message
...
Thanks Guys, but niether approach works
I need A1,A2... to reflect the actual day name of the date in Col B,
depending on the date today (this a simple rolling monthly ss)
ie next month, Col A will automatically change (day name) to reflect the
actual month.
Cheers
Mathew
"Mathew P Bennett" wrote in message
...
Good Evening All, I have a simple 3 column s/s, which details direct
debit outgoings for each day of the Month, ie 1-31. Because of the
change of day of month (Mon/Tue...) falls differently each month, ie Mon
1st June, might be Mon 2nd July. So...

A B C
1 01 £1000.00
2 02
3 03 £500.00
4 04 £350.00
5 05

...So depending on the date (today), I would like column A to show the
actual day of the week, Mon/Tue/Wed etc. I have tried linking to a
absolute cell with the Today() fn, and even tried to create a vlookup
table in another w/s but to no avail.
I hope eplained ok! Us usual any assistance is most appreciated.

Cheers, Mathew