Posted on February 22, 2005, 10:44 PM, by Chad, under
general.
I sometimes think that if it weren’t for conditional logic, Excel would be practically useless. I use Excel alot, just about every day. And just about every day, it aggravates me. But then there are the times when I figure something out, some cool way to convert numbers or perform a calculation, and Excel has [...]
Posted on August 2, 2004, 11:12 AM, by Chad, under
general.
This isn’t rocket science, but I found it useful (once I got it right), especially when you have 20,000 records to extract the day from, as I often do. This works for dates formatted as such:
1/1/2001 (without leading zeros on the month or day)
and will give you the day, in the above case: [...]
