Excel Datevalue

Compare Dates

This post will guide you how to compare dates if it is greater than a given date in excel. How do I compare a list of dates with a specified date using a formula in Excel. Compare Dates Assuming that you have a list of data that contain date values in Excel, you can use… read more »

Convert Date to Text

This post will guide you how to convert dates stored as text format in Excel. How do I convert the date as date format to text format in excel. You can use a variety of formulas to convert the dates in your worksheet to text format. You can use the TEXT function to create a… read more »

Convert Month Name to Number

This post will guide you how to convert month name to number in excel. How do I convert month name to number with an excel formula. How to convert month name to number with an Excel VBA macro. How to convert 3 letter month abbreviation to number in excel. How to convert 3 character month… read more »

Excel DATEVALUE Function

This post will guide you how to use Excel DATEVALUE function with syntax and examples in Microsoft excel. Description The Excel DATEVALUE function returns the serial number of date. And it can be used to convert a date represented as text format into a serial number that recognizes as a date format. For example, you… read more »

Excel MONTH Function

This post will guide you how to use Excel MONTH function with syntax and examples in Microsoft excel. Description The Excel MONTH function returns the month of a date represented by a serial number. And the month is an integer number from 1 to 12. And you can use the MONTH function to get a… read more »

Excel TODAY Function

This post will guide you how to use Excel TODAY function with syntax and examples in Microsoft excel. Description The Excel TODAY function returns the serial number of the current date. So you can get the current system date from the TODAY function. The serial number is the date-time code used by Excel for date… read more »

Excel IF formula with “Equal to” logical operators

The “Equal to” logical operator can be used to compare the below data types, such as: text string, numbers, dates, Booleans.  This section will guide you how to use “equal to” logical operator in excel IF formula with text string value and dates value. Formula example Description =IF(A1=B1,“TRUE”,”FALSE”) Returns TRUE if a value in cell… read more »

Sidebar