>>Either TODAY() or NOW() will work, provided that they are in the right order, that is the second date should always be greater or equal than the first one, weird...
>>
>>
>>=DATEDIF("2019/01/15", "2018/03/17", "d") => #NUM
>>=DATEDIF("2018/01/15", "2018/03/17", "d") => 61
>>=DATEDIF(TODAY(), "2018/03/17", "d") => 65
>>=DATEDIF(TODAY(), "2017/03/17", "d") => #NUM
>>=DATEDIF("2017/03/17", TODAY(), "d") => 300
>>
>
>Thanks, this works.
>
>I had to remove the equal sign.
There is a simpler way I just tried and works... do not use datedif :)
= "2017/03/17" - TODAY() => -300
=TODAY() - "2017/03/17" => 300
You just need to remember to format the cell as number.
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges