Learn how to fnd the day of any date in Excel.

To extract the day from a date in Excel and find the day of any date, you can use the formula =TEXT(B5,/”dddd/”). This formula helps you convert a date into the day of the week. Simply enter a date into cell B5, and the formula will return the full name of the day (like /”Monday/” or /”Tuesday/”). To get the day from a certain date, place the date in B5 and use this formula to convert the date into the corresponding day. This method allows you to calculate and find the day of a date easily in Excel.

Explain using this formula

=TEXT(B5,/”dddd/”)

The formula =TEXT(B5,/”dddd/”) converts the value in cell B5 to a text string that represents the day of the week. Specifically, it uses the date value in B5 and formats it to display the full name of the day (e.g., /”Monday,/” /”Tuesday/”). This is useful for extracting and displaying the day of the week from a given date in a more readable format within a spreadsheet.

#shorts #short #shortvideo #fyp #excel #microsoft #tiktok #fypシ

Please take the opportunity to connect and share this video with your friends and family if you find it useful.