The DAY function extracts the day number (1-31) from a date, while the TEXT function can extract the day and display it in various formats, including the day name.