Chat with us, powered by LiveChat

DATEVALUE Function

Excel has a number of date functions.  Unfortunately, they don’t all work if Excel treats the date as text.  When working with downloaded data, sometimes the date must be converted from text to a format recognized by Excel. One method is to use the...

EOMONTH

Date Function EOMONTH EOMONTH displays the serial number of the last day of the specified month. You can use this to calculate maturity dates and due dates that occur on the last day of the month. In the example below, I have 1/2/2016 in cell A1. In another cell, I...