excel date

How to Convet Text Date dd/mm/yy to mm/dd/yyyy as Date Format

This post explains that how to convert text date in the format dd/mm/yy to the standard date format mm/dd/yyyy in excel. How to change dates in text format dd/mm/yy to mm/dd/yyyy as date format in excel 2013. Convet Text dd/mm/yy to mm/dd/yyyy as Date Format If you want to convert dates in the text format… read more »

Excel IF Function With Dates

If you have a list of dates and then want to compare to these dates with a specified date to check if those dates is greater than or less than that specified date. You can use the IF function in combination with logical operators and DATEVALUE function in Microsoft excel. Excel IF function combining with… read more »

Excel Date Function

This post will guide you how to use Excel DATE function with syntax and examples in Microsoft excel. Description The Excel DATE function returns the serial number for a date. The DATE¬†function is a build-in function in Microsoft Excel and it is categorized as a DATE and TIME Function. The DATE¬†function is available in Excel… read more »