Looking to convert dates that are listed in 5 digit numbers. dates with double digit months are 6 digits. An example would be 31618 to convert to 03/16/18. There are many different dates so I would love to be able to put a formula that will account for all of them. For example, the second date in table is 40518, 41218, 41718.
From there I want to be able to subtract 7 days from that date for all to account for a ship date. 7 days being the average transit.
Solved by S. A. in 27 mins