MOD function to automate a scheduling task

[PhysiqologyInc]

I want to create a numerical Week.Day format for a spreadsheet, such that "1.1" means "Week 1, Day 1", and so on.

I set up a validation table to create a starting point that is pulled from that table. The starting point can be any week, as well as any day.

In my data entry sheet, I want to be able to:
1) Assign a beginning time. Example 2.3 (meaning, Week 2, Day 3),
2) Assign a frequency of repeat, as in, how often this task is to be repeated,
AND (this is the part I cannot figure out)
3) Have successive columns produce the proper Week.Day format from the preceding two variables. So, if my first week.day is 2.3, and my repeat is 3 (every 3 days), I want the columns to read as such:
2.3
2.6
3.2
3.5
4.1, and so on.

 

[J.Ty.]

Honestly, this is a bad idea. You want to have your data in a format which violates 1st Normal Form. It stipulates that you should never put two pieces of information in a single cell. This is precisely what you are attempting to do and the difficulties you are experiencing indicate that pretty much everything will be much more complex than normally.

J.Ty.

 

[PhysiqologyInc]

Honestly, this is a bad idea. You want to have your data in a format which violates 1st Normal Form. It stipulates that you should never put two pieces of information in a single cell. This is precisely what you are attempting to do and the difficulties you are experiencing indicate that pretty much everything will be much more complex than normally.

J.Ty.

Alright. I will give this some additional thought, and see if I can break it down and make it work on my own. Thank you for the help.

 

[Peter_SSs]

I don't disagree that this may be complicating things. However, if you still want to proceed that way, see if this helps.

20 03 10.xlsm
	B	C	D	E	F	G
3	Start	2.3	2.6	3.2	3.5	4.1
4	Repeat	3
Week.Day

Cell Formulas
Range	Formula
D3:G3	D3	=INT((INT(C3)*7+10*MOD(C3,1)+$C4)/7)+MOD(INT(C3)*7+10*MOD(C3,1)+$C4,7)/10