Adding days

[mtagliaferri]

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????

 

[barry houdini]

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]

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
	A	B	C	D	E	F
1	MONDAY	2	TUESDAY		MONDAY
2	TUESDAY	5	SATURDAY		TUESDAY
3	SATURDAY	2	SUNDAY		WEDNESDAY
4	SATURDAY	3	MONDAY		THURSDAY
5	WEDNESDAY	5	SUNDAY		FRIDAY
6	MONDAY	7	SUNDAY		SATURDAY
7	MONDAY	8	MONDAY		SUNDAY
8	FRIDAY	4	MONDAY
9
Add Days

 

[mtagliaferri]

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]

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]

Did you have a problem with my suggestion? Here's an illustration

Book1
	A	B	C	D
1	Tuesday	Monday	Wednesday
2	5	2	70
3	SAT	TUE	TUE
4
Sheet1

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