This is what happens when you spend too much time in Excel Go have a break and get some life
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 not that.
We need this to be documented s8mewhere So, here it is
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.
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 fixed-length ID (mainly having leading zeros) And here is the formula
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 found myself needing to open a lot of these boxes, to track accounts, or loans, or virtual business partnerships between multiple partnerrs. And this is […]