Hello, my wife and I are in the process of emigrating from the UK to Canada and I'm trying to build a spreadsheet that will calculate in real-time when we're eligible for Canadian Citizenship.
To qualify, you need to have spent 1095 days (3 years) out of the previous 5 physically present in Canada. I have column B which is the date and column C which is the country we spent that day in, which I will populate every couple of weeks
So far I've assumed for the sake of argument that we will complete a 'landing trip' to activate our permanent residence on May 6th and then just filled sample data in column C. I'm trying to calculate the earliest date we would be eligible for citizenship and have that date automatically update depending on how many days we spend in the country.
Does anyone have a suggestion for a formula that could work please?
https://www.dropbox.com/s/7k6i6l4h9rm2f8f/Capture.PNG?dl=0
To qualify, you need to have spent 1095 days (3 years) out of the previous 5 physically present in Canada. I have column B which is the date and column C which is the country we spent that day in, which I will populate every couple of weeks
So far I've assumed for the sake of argument that we will complete a 'landing trip' to activate our permanent residence on May 6th and then just filled sample data in column C. I'm trying to calculate the earliest date we would be eligible for citizenship and have that date automatically update depending on how many days we spend in the country.
Does anyone have a suggestion for a formula that could work please?
https://www.dropbox.com/s/7k6i6l4h9rm2f8f/Capture.PNG?dl=0
