DATEDIFFERENCE

Returns the difference between two dates.

start_date	The date that represents the starting date of the period.
end_date	The date that represents the finishing date of the period.
unit	The type of information you want returned: "d","D" = number of days between "start_date" and "end_date" "m","M" = number of months (whole months) between "start_date" and "end_date" "y","Y" = number of years (whole years) between "start_date" and "end_date" "md","MD" = number of days between "start_date" and "end_date" (ignoring months and years) "yd","YD" = number of days between "start_date" and "end_date" (ignoring years) "ym","YM" = number of months between "start_date" and "end_date" (ignoring days and years)
date_format	(Optional) The date format "UK" or "US".

Remarks

* This is a replacement for the DATEDIF backwards compatibility function.
* If you are including the date directly then it must be enclosed in double quotes.
* The equivalent VBA function is DATEDIFFERENCE

	A	B
1	=JS.DATEDIFFERENCE("01 Jan 2020","04 Jan 2020","D")	1/1/2020
2	=JS.DATEDIFFERENCE("01 Jan 2020","1 Apr 2020","D")	1/20/2020
3	=JS.DATEDIFFERENCE("01 January 2020","04 Jan 2020","D")
4	=JS.DATEDIFFERENCE("01 Jan 2020","1 April 2020","D")
5	=JS.DATEDIFFERENCE("1/1/2020","4/1/2020","D")
6	=JS.DATEDIFFERENCE("1/1/2020","1/4/2020","D")
7	=JS.DATEDIFFERENCE("1/1/2020","1/4/2020","D","US")
8	=JS.DATEDIFFERENCE(1/1/2020,4/1/2020,"D")
9	=JS.DATEDIFFERENCE(1/1/2020,1/4/2020,"D")
10	=JS.DATEDIFFERENCE(1/1/2020,1/4/2020,"D","US")
11	=JS.DATEDIFFERENCE("01 Jul 2019","01 Aug 2020","d")
12	=JS.DATEDIFFERENCE(1/7/2019,1/8/2020,"d")
13	=JS.DATEDIFFERENCE(1/1/2020,20/1/2020,"D")
14	=JS.DATEDIFFERENCE("01/01/2020","01/20/2020","d")
15	=JS.DATEDIFFERENCE("01/01/2020","20/01/2020","d")
16	=JS.DATEDIFFERENCE(D1533,D1534,"d")
17	=JS.DATEDIFFERENCE("1/1/2020","1/20/2020","M")
18	=JS.DATEDIFFERENCE("1/1/2020","20/1/2020","m")
19	=JS.DATEDIFFERENCE(1/1/2020,20/4/2020,"M")
20	=JS.DATEDIFFERENCE(1/1/2020,20/4/2020,"m")

1 - How many days are there between 1 Jan 2020 and 20 Jan 2020.