When Excel tells you to go get some life
This is what happens when you spend too much time in Excel Go have a break and get some life...
DayName
Simplest way to get name of day as cell output from a date. Because you can custom format a cell with date to show only...
Shades of gray
We need this to be documented s8mewhere So, here it is...
Recover the unrecoverable
Working a lot with Excel means seeing lots of errors and bugs inside Excel Some of those are not likely bugs, but more like reaching...
Fixed length ID
I needed few months back to make a fixed-length ID iut if none-fixed-length numbers. SO I used the function REPT with RIGHT to force all...
SimpleANBox
This is a financial box, a saving account, a credit, a loan, or any other financial amount that has input and output. During my time...