Posts Tagged ‘excel’

The IF function: Excel’s saving grace

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 [...]

Extract day from date in Excel

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: [...]