Excel - month and weekday from date

For month (or day), formula is =MONTH (A1) [or =DAY(A1)]

For weekday name, the formula is =WEEKDAY(A1) then use custom format of DDD to show the day name