| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Name The Day Of The Date2
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Name The Day Of The Date2
Sorry, bad formatting,
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 "Mathew P Bennett" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Name The Day Of The Date2
Put this formula in A3:
=TEXT(DATE(YEAR(A$1),MONTH(A$1),TRIM(B3)),"DDD") and copy down. Hope this helps. Pete "Mathew P Bennett" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Name The Day Of The Date2
Hi Pete, Magic Thank you. Mathew
"Pete_UK" wrote in message ... Put this formula in A3: =TEXT(DATE(YEAR(A$1),MONTH(A$1),TRIM(B3)),"DDD") and copy down. Hope this helps. Pete "Mathew P Bennett" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Name The Day Of The Date2
You're welcome, Mathew - thanks for feeding back.
Pete "Mathew P Bennett" wrote in message ... Hi Pete, Magic Thank you. Mathew "Pete_UK" wrote in message ... Put this formula in A3: =TEXT(DATE(YEAR(A$1),MONTH(A$1),TRIM(B3)),"DDD") and copy down. Hope this helps. Pete "Mathew P Bennett" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Name The Day Of The Date2
A little shorter and less function calls...
=TEXT(A$1-DAY(A$1)+TRIM(B3),"ddd") Rick "Pete_UK" wrote in message ... Put this formula in A3: =TEXT(DATE(YEAR(A$1),MONTH(A$1),TRIM(B3)),"DDD") and copy down. Hope this helps. Pete "Mathew P Bennett" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
