Excel Tricks with Tejraj

In this blog post we will learn about MONTH function in excel. MONTH function returns month of the year from the selected DATE. Where to find MONTH function on Excel Screen: MONTH function can be found under “Date & Time" Function category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Date & Time” category, we can see list of various Date & Time Functions available in excel. MONTH function is highlighted in blue in below image. Once we click on MONTH option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of MONTH Function: The Syntax of MONTH function is as below: =MONTH(serial_number) Arguments of MONTH Function: To use the MONTH function, we have to provide only one argument: Serial_number : In this argument we have to enter a date from which we want to identify month. Need of MONTH Function: Now, the question is why we have to use this MONTH function? We will unde...

In this blog post we will learn about DAY function in excel.  DAY function returns day of the month from the selected DATE.  Where to find DAY function on Excel Screen: DAY function can be found under “Date & Time Function” category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Date & Time” category, we can see list of various Date & Time Functions available in excel. DAY function is highlighted in blue in below image. Once we click on DAY option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of DAY Function: The Syntax of DAY function is as below: =DAY(serial_number) Arguments of DAY Function: To use the DAY function, we have to provide only one argument: Serial_number : In this argument we have to enter a date from which we want to identify date. Why to use DAY Function Now, the question is why we have to use this DAY function? We will understand need of DAY f...

In this blog post we will learn about DATE function in excel. When we have Year, Month and Day as a three separate values then with the help of DATE function we can convert them into single value which will represent a particular date. Where to find DATE function on Excel Screen: DATE function can be found under “Date & Time Function” category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Date & Time” category, we can see list of various Date & Time Functions available in excel. DATE function is highlighted in blue in below image. Once we click on DATE option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of DATE Function: The Syntax of DATE function is as below: =DATE(year, month, day) Arguments of DATE Function: To use the DATE function, we have to provide three arguments: year : In this argument we have to enter a number from 1900 or 1904 (depending upon workbook’s da...

In this blog post we will learn about CODE function in excel. With the help of CODE function we can get numeric code for the character. In case of text string, it will return numeric code for 1st character in text string. Where to find CODE function on Excel Screen: CODE function can be found under “Text Function” category under “Formula Tab” as shown in below image: Once we click on “Text” category, we can see list of various Text Functions available in excel. CODE function is highlighted in red in below image. Once we click on CODE option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of CODE Function: The Syntax of CODE function is as below: =CODE(text) Arguments of CODE Function: To use the CODE function we have to provide only one arguments: text : This is the only one argument which have to provide. In this we have to provide a text for which you want code. Example of CODE Function: Let’s learn about using this CODE function wit...