I have been involved with a great stack of data over the last few months; building a massive formula that so far covers all the possible falsey input I can think of!

I’ve edited all cell references so it’s obvious where they lie; and not what they refer to. Personally I find cognitive search-and-replace really frustrating, and Excel has never made debugging input to its formula bar easy (I can only imagine the frustration a command-line PHP dev’ must have!)…

The magic started life as:

=IF(OR(I6="",K6=""),"?",NETWORKDAYS(I6,K6,))

Designed around NETWORKDAYS to figure out the amount of time between two user-defined dates; it makes a nominal effort to filter out bad data. Read More…

Yes, it is up to individual administrators and programmers to ensure this happens; this is how SEO was invented.

Since I think the top-most hit (at the time of writing this is “The Troll’s Den.com”) has been there for at least a few months; surely there should at least be some information shown off regarding why it’s there?…