M
Mathew P Bennett
Hi again Guys, thank you for the input, I have rejigged the sample below, to
try & show what I wish to achieve, ie that Col A (Row 3-31) shows he name of
the day relating to Col B (Row 3-31), relating to $A$1.
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 =Today()
2 Day Date Of Month Value
3 01
£1000.00
4 02
5 03
£500.00
6 03
£250.00
7 04
8 05
£500.00
9 05
£500.00
....So depending on the date (today), I would like column A (3 to 31) 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
try & show what I wish to achieve, ie that Col A (Row 3-31) shows he name of
the day relating to Col B (Row 3-31), relating to $A$1.
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 =Today()
2 Day Date Of Month Value
3 01
£1000.00
4 02
5 03
£500.00
6 03
£250.00
7 04
8 05
£500.00
9 05
£500.00
....So depending on the date (today), I would like column A (3 to 31) 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