lacviet2005
08-21-2007, 02:13 PM
Hi all gurus,
I'll try my best to explain the problem, but please see the attached worksheet to get a better idea.
I have a worksheet with cycle from 1 to 13 (combo box), every cycle has 3 weeks (ie, 1st, 2nd, and 3rd by using radio buttons). Now I want to calculate the number of days.
For example:
Cycle 1: Week: 1st = Day 0
2nd = Day 7
3rd = Day 14
Cycle 2: Week: 1st = Day 21
2nd = Day 28
3rd = Day 35
Cycle 3: Week: 1st = Day 42
2nd = Day 49
3rd = Day 56
etc... :bug:
I got it to work for cycle 1 and 2, but my formula is too messy and i'm stuck. If you have any other ways to do this, please let me know.
Thanks so much.
LV
I'll try my best to explain the problem, but please see the attached worksheet to get a better idea.
I have a worksheet with cycle from 1 to 13 (combo box), every cycle has 3 weeks (ie, 1st, 2nd, and 3rd by using radio buttons). Now I want to calculate the number of days.
For example:
Cycle 1: Week: 1st = Day 0
2nd = Day 7
3rd = Day 14
Cycle 2: Week: 1st = Day 21
2nd = Day 28
3rd = Day 35
Cycle 3: Week: 1st = Day 42
2nd = Day 49
3rd = Day 56
etc... :bug:
I got it to work for cycle 1 and 2, but my formula is too messy and i'm stuck. If you have any other ways to do this, please let me know.
Thanks so much.
LV