To convert a date to a week in Excel, use the WEEKDAY function. The WEEKDAY function takes a date as an input and returns the day of the week as a number. For example, if you enter the date "1/1/2019" into the WEEKDAY function, it will return 1 (Monday).