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 Excel formulas. especially after you understand 25% of these formulas.
But when you do, check out the library of VBA/Excel (aka macros, aka vbscripts) programming codes at BoldCodes.com or Bold.Codes
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 is easier Get the date …
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 helping me as reference, it …
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 Dec24, Jan4, Aug14Else 2020Feb4
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 rather than a function. Once …
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, and ActiveX control.
This was an interesting request. Needing to get the date of 3rd Wednesday for a given month, automatically, using pure Excel functions. So, sharing here on what is the formula …
