days remaining

[Jagat Pavasia]

I have date in my F1 like 12/03/2019 dd/mm/yyyy.

I want formula in H1 that how much days remaining from currant date of today.


Today is 08/03/2019, so answer in H1 should be "4".

and tomorrow this H1 should be "3", automatic by formula

 

[lrobbo314]

H1 = F1 - Today()

Be sure to format H1 as 'General' because it will automatically format it as a date and look like '5/1/1900'.