Tom’s Tutorials For Excel: Doing Date Math on Text (non real) Dates
In yesterday’s tutorial, I showed how to place a date and time on separate lines in the same cell.
That example involved a formula with the
TEXT function, meaning the date and time value in cell A3 was not a real date or real time, but a constant text value that was not unlike a text sentence such as you are reading now.
However, you start to have some luck with a formula to return all to the left of
…which returns the serial number of (in this example) the date in cell C3 + 1, which is July 18, 2013.