Dear Excel Gurus
I would be grateful for your collective thoughts on how to add days in school terms. I am sure it will be an IF(AND) scenario but can't seem to figure it out.
We have 3 terms at school, each 8 weeks long, therefore 56 days. Students achieve various goals within each of these terms and I would like a formula to add up the total number of days to reach that particular goal.
If a student achieved the grade in week one, day four, the days taken would be 4, if they achieved the score in week 2, day four, the days taken would be 7+4=11. However, in term 2, week one, day four the days taken would be (56) +4
How would I express that in a formula please, that could account for 3 terms? A student might reach the goal on Term3, Wk 7 day 5 which, by my reckoning would be (56+56) + (6*7) + 5. Two terms of 56 days plus 6 weeks and the 5 day of week 7?
I hope that makes sense and I wold greatly appreciate your insight.
My rudimentary part of term spreadsheet looks like this:
[TABLE="class: grid, width: 4, align: center"]
<tbody>[TR]
[TD]T[/TD]
[TD]W[/TD]
[TD]D[/TD]
[TD]Days[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]56+7+4[/TD]
[/TR]
</tbody>[/TABLE]
Many thanks
I would be grateful for your collective thoughts on how to add days in school terms. I am sure it will be an IF(AND) scenario but can't seem to figure it out.
We have 3 terms at school, each 8 weeks long, therefore 56 days. Students achieve various goals within each of these terms and I would like a formula to add up the total number of days to reach that particular goal.
If a student achieved the grade in week one, day four, the days taken would be 4, if they achieved the score in week 2, day four, the days taken would be 7+4=11. However, in term 2, week one, day four the days taken would be (56) +4
How would I express that in a formula please, that could account for 3 terms? A student might reach the goal on Term3, Wk 7 day 5 which, by my reckoning would be (56+56) + (6*7) + 5. Two terms of 56 days plus 6 weeks and the 5 day of week 7?
I hope that makes sense and I wold greatly appreciate your insight.
My rudimentary part of term spreadsheet looks like this:
[TABLE="class: grid, width: 4, align: center"]
<tbody>[TR]
[TD]T[/TD]
[TD]W[/TD]
[TD]D[/TD]
[TD]Days[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]56+7+4[/TD]
[/TR]
</tbody>[/TABLE]
Many thanks