For example DATE 2017142 returns the serial number representing February 2 2018. Select the dates you want to find the approaching dates and click Kutools Select Select Specific Cells. Earlier Date is the date before the Later Date.
Create a second column heading called Due Date in column B or next to the first column.
Kutools for Excels Date Time Helper feature also provides an quite easy way to quickly calculate expiration dates in ExcelPlease do as follows. Excel will add the number of months to the first month of the specified year. If you want to count by months you can use the EDATE function which returns the same date n months in the future or past. The working days function can calculate anything that depends on the of work days or business days.