Date format in Excel for Windows & Mac

[captain_one]

Hi,

I use Excel 2010 (Windows). My SUMIFS formula is working correctly on my computer. I send this file to my client who uses Excel for Mac 2011 and the formula does not work.

The formula is =SUMIFS($H$2:$H$233,$B$2:$B$233,A4,$A$2:$A$233, ">"&"31/12/2014"). This is working correctly on my computer. It shows a number say 5 on my computer. On my client's computer, this shows a blank cell.

Now, I know this problem is related to the date part in my SUMIFS formula because earlier when the formula was without the date range and date criteria, it was working correctly.

I have tried using the 1904 date system in my excel, still the problem persists.

What could the issue be? Could it be that I should try "12/31/2014" instead of "31/12/2014"?

Thanks for your help.

[etaf]

The date you have entered is seen as text and NOT a date

try
=SUMIFS($H$2:$H$233,$B$2:$B$233,A4,$A$2:$A$233, ">"&DATEVALUE("31/12/2014"))

Now A4 criteria
is also part of your daterange

[captain_one]

Using the DATEVALUE() function solved the issue. The formula now works correctly on both my and my client's computer.
Thanks a lot Wayne!

[etaf]

your very welcome and thanks for the rep