Help with excel spreadsheet not populating correct dates

[kjglen87]

Hello,

I was wondering if anyone could help? I have designed (along with a friend) a spreadsheet to use for my MA in Education. I have come to my new school to use it and the dates aren't working properly.

If you click on Year 11 Tab, then I put a previous date in and the review dates work. But if I put today's date in on the year 10 tab the review dates go backwards even though it is the same formula.

If anyone could take a look and help, I would be so grateful.

Here is a link to the spreadsheet

https://1drv.ms/x/s!AhnSY8WjXrzZsDhrhd8TnWVfW8Vt

 

[Fluff]

It's because your final exam date is before today