Excel Functions

The Weekdays in Excel

There are a few ways of getting the Weekday in Excel. if you require the number of day in a Week for the given date then may use then WEEKDAY function. If you require short day name then use the TEXT function

How to Count in Excel?

if you require the count of cells that contain numbers only, use the Excel COUNT function.
To get the count of all cells with numbers, text, dates etc except the blank cells, use the COUNTA function. Similarly, for returning the count of cells based on certain criteriause the COUNTIFS function. To get the count of blank or empty cells, use the COUNTBLANK function.

The TEXT function in Excel

The Excel TEXT function can be used to convert numbers and dates into text. This is particularly useful for scenarios where you require displaying the numbers or dates with text strings. For example: