This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

How to extract day from date?

Posted on 08-14-2020 06:38 PM
Fir
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

How to extract the day from the date. For example, if the given date is 15 August 2020, I want to know the day for that particular date i.e. Saturday. Please help me on this. Thank you.

0 3 167
Topic Labels
0 Likes
3 REPLIES 3

Posted on --/--/---- --:-- AM
hru
Gold 1
Gold 1
Reply posted on --/--/---- --:-- AM 
SWITCH(
  WEEKDAY(TODAY()),
  1, "Sunday",
  2, "Monday",
  3, "Tuesday",
  4, "Wednesday",
  5, "Thursday",
  6, "Friday",
  "Saturday",
)

Posted on --/--/---- --:-- AM
Fir
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

Thanks

0 Likes

Posted on --/--/---- --:-- AM
Suvrutt_Gurjar
Platinum 1
Platinum 1
In response to Fir
Reply posted on --/--/---- --:-- AM

Or as below

TEXT(TODAY(), โ€œDDDDโ€)

Top Labels in this Space