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