Adding days

mtagliaferri

Board Regular
Joined
Oct 27, 2004
Messages
143
Hi all, I have this proble I would like to solve: in A1, A2, A3 ... the week days in the following format MONDAY, TUESDAY WEDNESDAY..... I B1 I have the number of days of lenght as 2, B2 as 5....I would like as result in C1 to be A1+B1 = TUE in C2 the result as SAT.
To make it more clear:

MONDAY + 2DAYS = TUE
TUESDAY + 5DAYS = SAT

Is this possible????
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
Perhaps this formula in C2 copied across

=IF(OR(A1="",A2=""),"",TEXT(MATCH(LEFT(A1,2),{"Mo","Tu","We","Th","Fr","Sa","Su"},0)+A2,"ddd"))


....if you need the day to be in upper case change to

=IF(OR(A1="",A2=""),"",UPPER(TEXT(MATCH(LEFT(A1,2),{"Mo","Tu","We","Th","Fr","Sa","Su"},0)+A2,"ddd")))
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
50,553
Office Version
  1. 365
Platform
  1. Windows
mtagliaferri

Is this any use?

1. List of days in E1:E7
2. Formula in C1 (copied down):
=INDEX($E$1:$E$7,MOD(MATCH(A1,$E$1:$E$7,0)+B1-2,7)+1)
Mr Excel.xls
ABCDEF
1MONDAY2TUESDAYMONDAY
2TUESDAY5SATURDAYTUESDAY
3SATURDAY2SUNDAYWEDNESDAY
4SATURDAY3MONDAYTHURSDAY
5WEDNESDAY5SUNDAYFRIDAY
6MONDAY7SUNDAYSATURDAY
7MONDAY8MONDAYSUNDAY
8FRIDAY4MONDAY
9
Add Days
 

mtagliaferri

Board Regular
Joined
Oct 27, 2004
Messages
143
Thanx for the quick reply, I have tried both suggestions but I do have a error, I have tried the second sample on a clear new sheet and I have a error highlighting $E$7,MOD
Any clue why it is not working :(
Thnx
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
50,553
Office Version
  1. 365
Platform
  1. Windows
Thanx for the quick reply, I have tried both suggestions but I do have a error, I have tried the second sample on a clear new sheet and I have a error highlighting $E$7,MOD
Any clue why it is not working :(
Thnx
Are you using a standard English version of Excel?
Can you copy and paste your formula to the board?
 

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
Did you have a problem with my suggestion? Here's an illustration
Book1
ABCD
1TuesdayMondayWednesday
25270
3SATTUETUE
4
Sheet1


As Peter says, if you have a non-English version of excel you may have to modify the formula
 

Forum statistics

Threads
1,141,151
Messages
5,704,586
Members
421,358
Latest member
Redstar13

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top