simply Text(A1,”ddd”) or Text(A1,”dddd”) will work .

It works in Excel 2003 , so it should work in advanced versions of Excel as well. ]]>

Try pressing control key and q to get the input form, then select a year. ]]>

As for the DATEIF function, I saw many people use it, but as you said it is not documented. In such cases one should be careful. It may be dropped from a new release or update and then you are stuck.

Regards. ]]>

I actually found an obscure function which is not even documented by Microsoft, and when you start typing it, it’s not in the list of suggested formulae…

=DATEDIF(A1,A3,”y”)&” year(s), “&DATEDIF(A1,A3,”ym”)&” month(s) and “&DATEDIF(A1,A3,”md”)&” day(s)”

It works, but I get a little suspicious by the fact that MS are so secretive about it. Very strange indeed…

]]>Your feedback is appreciated. ]]>

protect-formula-cells-but-allow-access-to-data-cells-in-excel-2007-2010

]]>thanks ]]>

`=MOD(C2-B2;1)`

Replace “;” with “,” if required.

]]>http://www.dailydoseofexcel.com/archives/2004/05/11/conditional-data-validation/

]]>`=A1`

And since there is no Sort event to catch in Excel 2007, I let you imagine the fun I’m going to have to solve this.

]]>