ExcelKingTips | Daily Excel Magic on Instagram: "🧠 What the Formula Does - The TEXT function lets you convert a date into text using a custom format. - "dddd" tells Excel to extract and display the full name of the weekday (like "Monday", "Friday"). 📅 Why "dddd"? - "d" alone returns just the day number (e.g., 1, 15, 31). - "dd" gives a two-digit day (e.g., 01, 15). - "ddd" gives a short weekday name like "Mon" or "Fri". - "dddd" gives the full weekday name. for Month and Year If you also want

ExcelKingTips | Daily Excel Magic on Instagram: "⚠️ Note DATEDIF is a hidden function in Excel, so it won’t show in the function list, but it works fine. Comment "COURSE" to start mastering Excel! 190+ videos from beginner to advanced. Everything you need in one place.  85% OFF NOW  Explanation: A1 = the cell containing the date of birth. TODAY() = today’s date. "Y" = full years between the two dates (the age)."