Media Summary: Sometimes you get a file that has dates that don't seem to work like real dates (i.e., you can't perform calculations on it). Maybe ... Have dates that are "conveniently" seperated into seperate fields? Well this is the way to put it all together with the In cell I2 show, with the use of the proper
Excel 2016 Datevalue Function - Detailed Analysis & Overview
Sometimes you get a file that has dates that don't seem to work like real dates (i.e., you can't perform calculations on it). Maybe ... Have dates that are "conveniently" seperated into seperate fields? Well this is the way to put it all together with the In cell I2 show, with the use of the proper Sometimes you want to sort a list of dates. No matter what you do it just doesn't work. The reason? The "dates" are probably text ...
