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!
This will do the job.
A1 must contain a Date & Time value (set to show 'time' as 'none')
A2: =DAYNAME(WEEKDAY(A1))
Regards,
Barry