You can use the Text Function as well as Format Cell option to display weekday for a date in excel. Using Text Function display with formula and format cell option is done without any formula.
Usually, schools, attendance, and some business some datasets require the dates to display weekday, month or only year in the cell. The cell contains the actual date but it displays only the weekday. Similarly, some require to display the weekday next to the respective date.
You can do this in two different ways:
Let us understand each in detail.
The TEXT function converts a numeric value to a text string and displays it in the specified format. The syntax for the TEXT Function is as follows:
=TEXT ( Cell Reference/Value, Format-Text)
You can use this function to display weekday, month, or year for a given date. Using this option, you can display the result in a new cell or the same cell.
You can display a given date in multiple formats using the TEXT Function as shown in the image below:
To display the result in the same cell you have to type the date in the formula along with the desired format string. Whereas to display in the adjacent cell give the cell reference and the desired format.
In the top ribbon, the Number Tab consists of Format Cell Option. You can select the desired format of the date to display.
Follow the below-mentioned steps:
See the image below:
In this option, the cell displays the date in the background. Thus, when you want to display the original date, just select the desired option of short or long date from the Number tab in the ribbon.
Additionally, you can check out How to Create Dynamic Hyperlink In Excel – 3 Easy Steps.
We thank our readers for liking, sharing and following us on different social media platforms.
If you have any queries please share in the comment section below. We will be more than happy to assist you.
To simplify the process, we have created a simple and easy UK VAT Taxable Turnover…
Every business has to register for VAT with HM Revenue and Customs if their VAT…
We have created the UK VAT Dual Currency Invoice excel template with predefined formulas that…
We have created a simple and easy UK VAT Purchase Register Excel Template with predefined…
We have created a simple and easy UK VAT Sales Register Excel Template with predefined…
We have created a ready to use UK VAT Progress Billing Invoice template in excel…