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.


 A
1=TODAY() = Sunday 19 May 2024
2=NOW() = Sunday 19 May 2024 13:52:44
3=TEXT(A1, "dddd") = Sunday
4=DAY(A2) = 19
5=CHOOSE(WEEKDAY(TODAY()), "Su", "Mo", "Tu", "We", "Th", "Fr", "Sa", "Su") = Su

1 - Display a date
2 - Displays the date component of the date in cell A1
3 - Displays the date with the custom number format "dddd" applied


Built-in Functions

NOW - The date serial number of the current system date and time.
TODAY - The date 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.


Related Formulas

Return the current date and time
Return the current date
Return the current month
Return the current time
Return the current year
Return a date in a particular format


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top