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 …
Standard functions that comes with Excel, plain single functions
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 …
Looplist – Repeating months using formulas
Using formulas to repeat list, I call it LoopList Used to list Months for several years, in away that with 1 formula, it will loop through all months, then jumps …
Scorring, saving multiple outputs in 1 number
I have seen this practice before several locations Returning multiple outputs in 1 single number. for example
Expenses calendar, FaCal
Expenses calendar, to show when in a month you need to pay what bill An easy formula-only smart sheet to allow you get hold on your bills Refreshes every time …