Use `=DAY(A1)` to return the day number from a date in cell A1
Replace `A1` with the cell that contains your date
If the date is stored as text, convert it to a real date first
Use `=TEXT(A1,”d”)` to display the day as text
Use `=TEXT(A1,”dd”)` to display the day with a leading zero
Use `=DAY(TODAY())` to extract the current day from today’s date
Use `=DAY(DATE(2024,12,25))` to extract the day from a specific date
Format the result cell as General or Number if needed
Use `=DAY(INT(A1))` if the date-time value includes a time portion