We need this to be documented s8mewhere
So, here it is
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 that day name This 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 the limit of the application.
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 numbers to be converted into …
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 with technology (since 1997) I …