Adding days

mtagliaferri

Board Regular
Joined
Oct 27, 2004
Messages
156
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

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

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
56,527
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
156
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
56,527
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,175,844
Messages
5,899,782
Members
434,798
Latest member
dragontbone

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