Hi,

I've just joined today, so I'm sorry if i post this message in the wrong place or I'm not clear in my explanation.

I work in a school and i want to calculate the best possible attendance of a student based on their current attendance vs number of school days remaining.

There are 190 school days in a year.

For example, if a student is currently on 47% attendance and there are only 31 days left of the school academic year, what is their best possible attendance if they came to school every day.

So, I need a spreadsheet that can work out values based on all possible attendance and all possible number of school days remaining.

Thanks.