You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

32 points

Displaying the day of the week ?

Hello, I am wondering if numbers can display what the day of the week is for a given cell so for example

Cell A1 Cell A2

"18/12/2017 " "Monday"

Does anyone know if this is possible? Thanks!

Posted on May 25, 2020 9:48 AM

Top-ranking reply

Level 9

59,951 points

Posted on May 25, 2020 11:38 AM

This will do the job.

A1 must contain a Date & Time value (set to show 'time' as 'none')

A2: =DAYNAME(WEEKDAY(A1))

Regards,

Barry

View in context

Similar questions