xls tries to open with excel services when searching

Scenario:
I had an issue with excel documents trying to open with Excel Service when using search. Although Excel Services wasn’t even configured on the Sharepoint Server.
When looking at the Site level, feature for always open with clientprogram was activated. Same thing at the list-level, Server default was activated.
Workaround Solution:
When searching, check for preferences at the bottom


Activate Open in the browser. This will probably only solve for the current user, but if in a tight spot.

Excel datedif formula

Useful excelformula that is hidden from the common gui, but present in all version of excel.

To compare a date to today

=DATEDIF(A1,TODAY(),"d")

Outputs difference in days. Can also return in complete months, years and then some.

D	Number of days
M	Number of complete months
Y	Number of complete years
YD	Number of days excluding years
MD	Number of days excluding months and years
YM	Number of months excluding years

Note that on Swedish systems formulas look like this instead:

Comma is replaced by semicolon for some reason.

References:

http://excel.datedif.com/

http://stackoverflow.com/questions/10928586/excel-calculate-the-date-difference-from-today-from-a-cell-of-7-6-2012-102642