When Excel functions are not enough
BoldCodes BoldCodes is here to help (BoldCodes.com or Bold.Codes), even though I doubt it, I mean the fact that you cannot do your task in...
Middle name + 1st name
Get the initial (middle name) from a triple name in a cell.C4 The cell contains the triple name separated with spaces.=LEFT(C4,1) & "." & MID(C4,...
LastSunday, LastSaturday
Get the date of the most recent SUNDAY for a specific date:D12 is the cell containing the date =D12 - WEEKDAY(D12) + 1 While Saturday...
Paste Special Percentage
One of many tricks that we overlook due to the huge number of possibilities in Excel and its functions. This one I wanted to keep...
Jan8 date format
Format a date in shortest format possible indicating how many days have passed (Past date) If date1-date2 < 8 Sat, Fri, …If date1-date2 < 350...
Filter. Google Sheets function
Interesting seeing Google Sheets doing things differently than Excel. This function will fill in cells as values once the user presses Enter. Technically a feature...
Walking Columns
An easy way to scroll through set of data in a graphic way without graphs. A-pure-formula xlsx workbook. These were done using formulas, conditional formatting,...
Unix DateTime Number
Convert Date/time number from regular number to Unix DateTime Number....