Updating date in excel selling dating book
I got to thinking later that there’s a simpler formula to extract the Date from a Date-Time value, which is =INT(A2).
After you enter this formula, the cell formatting needs to be changed to a Date format.
The table below provides some examples of inputs for an M&A mining transaction.
By this stage all the data that is required, plus a lot more besides, has been imported into your model.
The problem for me was that the LEFT function returns a “text” value.