Convert Date/time number from regular number to Unix DateTime Number.
Tag: DATE
Get 3rd Wednesday of month
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 and how to get there.
Lesson learned: Do not trust Google Sheets function
It wasted few days, hitting my head at the wall.My mistake …. I trusted that Google Sheets function called GoogleTranslate is working as it is expected. Which is not You just hate when that happens.We all know that Google is still a child in worksheet world, comparing to Microsoft, they are kids, but I wouldn’t…
Read More “Lesson learned: Do not trust Google Sheets function” »
Excel keeps converting all cells to “Date” (or Time)
Issue found several times in xls or xlsx, to get it fix https://www.mrexcel.com/forum/excel-questions/637277-excel-converting-numbers-dates.html
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 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 the core to it.