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

Hi Mathew

=DAY(TODAY())

Format the cell as custom, Type: dddd

Regards,
Per

"Mathew P Bennett" skrev i meddelelsen
...
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

One way to approach this is to simply enter the date in A1:
7/1/08
And then custom format A1 to
ddd or dddd
and then just copy down.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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

Maybe this:

Enter this formula in A1. It'll return the date for the 1st of the month for
the *current* month/year:

=TODAY()-DAY(NOW())+1

Enter this formula in A2 and copy down to A31:

=IF(DAY(A1+1)DAY(A$1),A1+1,"")

Select the range A1:A31 and format as DDD or DDDD

--
Biff
Microsoft Excel MVP


"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

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

Hi Guys, forgot to mention that in Col B (Date of the Month), there may be
duplicate rows, ie there may be 03 in B4 as well as B3
Cheers, M

"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

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

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

On Wed, 9 Jul 2008 19:49:12 +0100, "Mathew P Bennett"
wrote:

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

If 09 Jul 08 means 09 Jul 2008 then the formula you got from Biff is not
reflecting the date.

Most likely, you do NOT have a real date in B1, but rather just a number.

For example, if you had the number 9 in B1, instead of the date 09 Jul 08, then
Excel would interpret the "9" as being equivalent to 9-Jan-1900 which is a
Monday.

That being the case, you could use:

=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),B1),"dddd" )

--ron

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