Text & Date Functions
Lessons
Practice file
⬇ Download m5-text-dates-practice.xlsxText & Date Functions practice workbook
Use m5-text-dates-practice.xlsx for all five lessons. Fill the yellow cells and compare with Answers after trying. Formulas in Answers are text examples to copy into the specified sheet. Read Me explains the setup.
| Lesson | Sheets | Practice |
|---|---|---|
| 1 | Text Basics, Invoices | Clean ten names, handle control/non-breaking spaces, extract numeric years and preserve zero-prefixed serials. |
| 2 | Split Join, Split Practice | Join names/cities, skip blanks, split horizontally/vertically and format dates/amounts inside text. Keep spill cells empty. |
| 3 | Flash Fill, Flash Answers | Use provided first-row examples, audit middle/single-word names, and compare static results after changing a source value. Run Flash Fill in Excel. |
| 4 | Employees, Date Functions | Tenure, month-end, working days, leap year, equal/reversed dates and live TODAY/NOW examples. |
| 5 | Text Dates | Convert genuine text values with DMY/YMD rules, prove their types and calculate days to 31-Dec-2026. |
हिंदी: पीले सेल भरें। Flash Fill खुद Excel में चलाएँ। Employees में H1 पहले 01-Oct-2026 की स्थिर तारीख़ है ताकि उत्तर जाँच सकें; फिर चालू महीने के अभ्यास के लिए =TODAY() लगाएँ। दोनों भाषाओं में sheet names और cell references समान हैं।
The only sample holiday is 02-Oct-2026; this is an exercise calendar, not a complete holiday schedule. Fixed-date examples use Excel's 1900 date system. TODAY/NOW results change on recalculation. TEXT month names and formula separators may vary with locale.
TEXTSPLIT is available in Microsoft 365 and Excel 2024; use Text to Columns on a copy if unavailable. See Microsoft's TEXTSPLIT documentation. The workbook contains no macros or external connections.