Tools tagged #spreadsheet
Every ecech. tool tagged spreadsheet: 3 free calculators and utilities across Date, Time & Timezone, Developer & Code. No signup, runs in your browser.
💻
Column Letters
A is 1 and Z is 26, so the next is AA rather than A0. That missing zero digit is why the obvious conversion gives the wrong answer.
Developer✏️Excel Formula Builder
VLOOKUP defaults to approximate match and returns the wrong row when data is unsorted. This always writes the exact-match flag, and offers XLOOKUP, which has no such trap.
Text & SEO🕑Excel Serial Date
Serial 45658 is 1 January 2025. Serial 60 is 29 February 1900, a date that never happened — and Excel still ships that bug on purpose.
TimeRelated tags