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 ... 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 ... DATEVALUE(cell) This function can be used to take a text date and convert it into a
Excel Datevalue Function How To - 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 ... 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 ... DATEVALUE(cell) This function can be used to take a text date and convert it into a
