Updating date in excel selling dating book

updating date in excel-15updating date in excel-2updating date in excel-44

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.