Date calculations in excel 365

[Ntsokolo Memani]

How do I do date calculations in excel 365? I used to use the DATEDIF function with my earlier versions of excel but that function is no longer working. Is there an alternative way to calculate days, months, weeks or years between two dates?

 

[Fluff]

Hi & welcome to MrExcel.
DateDif still works in 365

 

[MARK858]

Works fine for me, what issue are you having?

Book5
	A	B	C
2	01/04/2004	15/06/2021	17
3			206
4			6284
5			14
6			2
7			75
Sheet2

Cell Formulas
Range	Formula
C2	C2	=DATEDIF($A$2,$B$2,"Y")
C3	C3	=DATEDIF($A$2,$B$2,"M")
C4	C4	=DATEDIF($A$2,$B$2,"D")
C5	C5	=DATEDIF($A$2,$B$2,"MD")
C6	C6	=DATEDIF($A$2,$B$2,"YM")
C7	C7	=DATEDIF($A$2,$B$2,"YD")

 

[bobsan42]

AFAIK the function is removed from the online version of excel.

 

[Ntsokolo Memani]

Works fine for me, what issue are you having?

Book5
	A	B	C
2	01/04/2004	15/06/2021	17
3			206
4			6284
5			14
6			2
7			75
Sheet2

Cell Formulas
Range	Formula
C2	C2	=DATEDIF($A$2,$B$2,"Y")
C3	C3	=DATEDIF($A$2,$B$2,"M")
C4	C4	=DATEDIF($A$2,$B$2,"D")
C5	C5	=DATEDIF($A$2,$B$2,"MD")
C6	C6	=DATEDIF($A$2,$B$2,"YM")
C7	C7	=DATEDIF($A$2,$B$2,"YD")

Well I feel very stupid now. In the previous versions I used "," and it worked just fine. Used it here with excel 365 and it just didn't work. The error message also didn't help things. For some reason I decided to use ";" and it worked just fine.

 

[MARK858]

For some reason I decided to use ";" and it worked just fine

Check the computers regional settings to make sure that the list separator is set as , not ;

 

[Fluff]

AFAIK the function is removed from the online version of excel.

It's still available with xl online

 

[MARK858]

It's still available with xl online

Works when I use it from my laptop online but not the version on my phone