📌 Formula:
=DATE(RIGHT(B7,4), MID(B7,3,2), LEFT(B7,2))
Table of Contents
🔹 Explanation:
If B7 contains a number like “25032024” (DDMMYYYY format), the formula:
- Extracts the year →
RIGHT(B7,4)→ 2024 - Extracts the month →
MID(B7,3,2)→ 03 (March) - Extracts the day →
LEFT(B7,2)→ 25
🔹 Example Output:
| Input (B7) | Converted Date |
|---|---|
| 25032024 | 25-Mar-2024 |
| 01012025 | 01-Jan-2025 |
✅ Now, Excel will recognize it as a date and you can format it as needed! 🚀
