Day of week Calculation

[Boris Petry]

I need to calculate a new day of week. I have a problem where I am only give a number between 1-7 representing the days of the week and I am trying to add a number of days to it. These days vary.

For example:

I have the following formula in the 3rd cell. =MOD(Z30+AA30,7). Works fine except for day 7, I can't get it to output 7 no matter what I try.

Am I missing something simple? I is also a problem if the start day say 6 and I add 1 day, it should output 7, but I get 0.

Please help, I am desperate.

 

[StephenCrump]

Welcome to the Forum!

Try: =MOD(Z30+AA30-1,7)+1

 

[Boris Petry]

Welcome to the Forum!

Try: =MOD(Z30+AA30-1,7)+1

Thanks Looks like it will work.