DATEDIF is not working with Excel Online. Any substitute function for this? Kindly help

Question

DATEDIF is not working with Excel Online. Any substitute function for this? Kindly help

Answer 1

MaheshKumar1 wrote:

Even though it is not listed, the function still works.

We can enter =DATEDIF(C1, D1, "d")

But there is no benefit to using DATEDIF for calculating days.

Just enter =D1 - C1

---

PS.... MSFT has been trying to deprecate the use of DATEDIF for many years. In Excel 2010, for example, it does not appear in offline help, and there is also no meaningful intellisense for the function. Nevertheless, the function persists. Click here for the online help page.

Answer 2

You can use

=date(2023,10,1)-date(2023,1,3)

If A1 and B1 is date format, you can also use

=B1-A1

Answer 3

Hi MaheshKumar1,

Greetings! Thank you for posting to Microsoft Community.

Could you share us which function of the datedif you want to use? Share some dummy data and expected result will also help to write a formula for you.

Best Regards,

Snow Lu

Answer 4

Datedif function is not listed in function

Answer 5

DATEDIF function - Microsoft Support

Which unit do you want to return?