What is HOUR function in Excel? The HOUR function is one of the Date & Time functions of Excel. It Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.J.). We can find this function in Date & Time category of the insert function Tab. How to use HOUR function in excel 2. […]

What is MONTH Function in Excel? The MONTH function is one of the Date & Time functions of Excel. It Returns the month, a number from 1 (January) to 12 (December). We can find this function in Date & Time of insert function Tab. How to use MONTH function in excel 2. Click on the fx icon (or press shift+F3). 3. […]

What is EDATE function in Excel? The EDATE function is one of the Date & Time functions of Excel. It Returns the serial number of the date which is the indicated number of months before or after the start date. We can find this function in Date & Time category of the insert function Tab. How to use […]

What is DATEVALUE function in Excel? The DATEVALUE function is one of the Date & Time functions of Excel. It Converts a date in the form of text to a number that represents the date in Microsoft Excel date-time code. We can find this function in Date & Time of insert function Tab. How to use DATEVALUE function […]

What is DAY function in Excel? The DAY function is one of the Date & Time functions of Excel. It Returns the day of the month, a number from 1 to 31. We can find this function in Date & Time of insert function Tab. How to use DAY function in excel 2. Click on the fx icon (or press shift+F3). 3. […]

What is DATE function in Excel? The DATE function is one of the Date & Time functions of Excel. It Returns the number that represents the date in Microsoft Excel date-time code. We can find this function in Date & Time of insert function Tab. How to use Date function in excel 2. Click on the fx icon (or press […]

What is the YEARFRAC Function in Excel? The YEARFRAC function is one of the Date & Time functions of Excel. It Returns the year fraction representing the number of whole days between start_date and end date. We can find this function in Date & Time category of insert function Tab. How to use YEARFRAC function in excel […]

What is WEEKNUM function in Excel? The WEEKNUM function is one of the Date & Time functions of Excel. It Returns the week number in the year. We can find this function in Date & Time category of insert function Tab. How to use WEEKNUM function in excel 2. Click on the fx icon (or press shift+F3). 3. In the insert […]

What is FORMULATEXT function in Excel? The FORMULATEXT function is one of the (Lookup & reference) functions of Excel It returns a formula as a string. We can find this function in Lookup & reference of insert function Tab. How to use FORMULATEXT function in excel 2. Click on the fx icon (or press shift+F3). 3. In the insert function tab […]

What is YEAR function in Excel? The YEAR function is one of the (Date & Time) functions of Excel. It Returns the year of a date, an integer in the range 1900 – 9999. We can find this function in Date & Time category of insert function Tab. How to use YEAR function in excel 2. Click […]