Assuming A1 contains the year (2008) and A2 contains the month (7) and B3
contains the day (1), the formula [watch wrapping in this post] ...
=CHOOSE(MOD(DATE($A$1,$A$2,B3),7)+1,"Sat","Sun","M on","Tue","Wed","Thu","Fri")
will evaluate July 01, 2008 as 'Wed' for 'Wednesday'.
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown


"Mathew P Bennett" wrote:

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