DATEDIF stopped being documented awhile ago, but it's still a valid function. Although my friend SirJB7 will (rightly) point out that ti does has some flaws when doing certain calculations.
Format for months is:
Also, a side note, the VB function DateDiff is also still valid, uses a lot of the same lettering, and is a little more robust.
Links to other websites work fine, unless those websites have reallocated their linked stuff (I don't remember right now which one, but I found issues at one of the usuals -peltiertech, contexture, etc.-).
Links to this website doesn't work to older links previous migration, and the built-in search feature which happened to work wow! in our tests in the real world it doesn't work for me at least.
Let me take the upward example, my loved topic about DATEDIF function originally titled "Excel 2007" started by Nitika.Kaul, yes, I remember that
The original link was: http://chandoo.org/forums/topic/excel-2007
The new link is: http://chandoo.org/forum/threads/excel-2007.3402
Even if I remember exactly the original topic and the original poster, I found almost impossible to find it quickly (1st search). I tried using this keywords:
- excel 2007
- excel 2007 datedif function
- excel 2007 nitika kaul
- excel 2007 sirjb7
- nitika kaul datedif
- ... and imagine any other combination and I tried it, with dash, without dash
I actually happened to find it using:
But this is not the easy way, imagine looking for VLOOKUP or more frequently used functions... if I always address the OP in my posts, why haven't I found "nitika.kaul datedif"?
As a matter of fact, unless I'm being so dumb that I don't realize how to perform a f.....g simple search, I don't find anything.
PS: f.....g stands for filling
PS2: More strange thing indeed. After having found anything like in the example, and performing again the same searches that failed first, many of them appear to work and they retrieve lots of entries that they originally didn't.
And this is more incomprehensible to me.
Another tricky thing I've noticed about our current search feature; sometimes the box for "Search only this forum" gets checked, and I need to uncheck it to make sure I'm looking at everything. Just a small thought.
And what if you don't know exactly the name and the member who started it? It isn't useful...
If only the links issue were solved, I described how to do it indeed, but... not even an answer.
PS: Ha ha ha... I've yet forgotten about that... (my post)