Office for Mac excel help

[DigitalSoldier]

Hi guys,

I hope somebody can help me I am trying to get the amount of days between two dates in excel.

I am using the formula:

A1 = 01/01/2014
B1 = 01/01/2013

=(a1-b1)

But I am just getting a value error. I have already tried changing the date format to English(UK) in both cells and still getting value error. I have even tried changing my region settings on my Mac to United Kingdom and still having the problem.

 

[ponder]

Try

=DATEDIF (A1, B1, "D")

 

[DrJohnZoidberg]

Hi guys,

I hope somebody can help me I am trying to get the amount of days between two dates in excel.

I am using the formula:

A1 = 01/01/2014
B1 = 01/01/2013

=(a1-b1)

But I am just getting a value error. I have already tried changing the date format to English(UK) in both cells and still getting value error. I have even tried changing my region settings on my Mac to United Kingdom and still having the problem.

Try:

A1 = 2014/01/01
B1 = 2013/01/01

 

[LaraC]

Use the following formula:

=DAYS(A1;B1)

 

[DigitalSoldier]

Try:

A1 = 2014/01/01
B1 = 2013/01/01

Thanks, this has worked and also after entering the dates like above excel changes the dates to the correct format ie:01/01/2014 and the calculation works.