I want to calculate the time in Years, Months and Days between todays date and some events in the past.
I want to store these values in a spreadsheet so that I can use the TODAY function, and have the durations recalculate whenever I open the spreadsheet.
Due to a family issue I have to complete forms that are stored on a Government Website. I need to set up an account to do this.
Part of the set up process for this account is an ID Check to prove it’s me.
Personal Circumstances meant that the available ID Checks were limited, and on this occasion I was asked questions about my Credit Report. The first time this has ever happened.
One of the questions I was asked was “When did I last open a current account?”. The answer was multiple choice: Last 2 years, 3-5 years, 5 years or more.
How long have you lived at your current address?
Calculating this sort of timing spurred my curiosity, and my interest in setting up the spreadsheet described above.
I have managed to calculate the years and months that have elapsed quite easily I think. I can just use the DATEDIF function on the two dates with Y as the Calc Method for the years and then “YM” for months. However, I’m a bit stumped with the days elapsed.