At 20:27 19/07/2014 -0400, James Lockie wrote:
I want the years since a date and today. I tried this function:
but it returns 1900.
Your first argument is 7 divided by 16 divided by 2,012. This is approximately 0.00022,
representing - as a date and time - nineteen seconds after midnight on the date origin. So I'd
expect the result to be 115. But in any case it won't have anything to do with a date in July
The arguments of YEARS() need to be numeric dates, so I think you need something like
I trust this helps.