Excel - subtract two date

Question

I have two date in twocolumn (Foramt cell - date)

 Column A        Column B
 30.12.2016        2.1.2017 

I need to substract two date and get result

I try this

=DATEDIF(A1,B1,"d")

but return me #VALUE.

I want to get numbers of days

Any idea?

Answer 1

This works if you use comma or dash or slash within the dates.
Like this: 30,12,2016 or 30-12-2016 or 30/12/2016
And also like this: 30,Dec,2016 or 30-Dec-2016 or 30/Dec/2016

See this: