Return the current day
You can display the day of the week by using the TEXT function.
If you do not want to display the full date you can apply the custom number format "dddd" to a cell that contains a date.
Cell "A1" display a date
Cell "A2" displays the date component of the date in cell A1
Cell "A3" is the same date with the custom number format "dddd" applied
NOW - The serial number of the current system date and time.
TODAY - The serial number representing today's date.
DAY - The day as an integer given a date serial number.
TEXT - The number as a formatted text string.
CHOOSE - The value in a row (or column) based on an index number.
WEEKDAY - The day of the week for a given date.
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top