Excel 2024/01/01. Power query is built in to windows versions of office 365, excel 2016, excel 2019 and is available as a free download in windows versions of excel 2010 and excel 2013. For example, if you input 01 or 1 in the year argument, your date formula will return the year of 1901.
You can break out the year, month, day and then put it. Previous posts on this topic include: