DATEVALUE Function

Oct 5, 2016 | Date functions, Functions

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

Jan 10, 2016 | Date functions

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...

Using Workday to Calculate Invoice Dates

Feb 20, 2015 | Date functions, Functions

This is just a quick tip as Excel is not necessarily that date friendly. If you want to calculate an invoice date or a project completion date use the WORKDAY() function. Select a cell and then select the Formula tab and then select Date& Time The syntax is as...