Suppose, we have
individual cell consists individual values of year, month and day.
Like the below image,
From those individual
values of the year, month and day, we want to create a valid date format by referencing
those cells.
To do that, we will
choose the blank cell below the label DATE FORMAT and start
typing “=Date” and then click on the suggested DATE function like
previously done but here we will not input values manually.
We will select those
cells A2, B2 and C2 respectively and these values will also be separated with a
comma (keep in mind) and after completion of referencing those cells just press
enter of your keyboard and you will get a valid date format as a result.
Look at the below GIF
carefully to get a clear concept about it.
That’s all for today. Stay with tutorialabc and if you have any query or
suggestions for us, please feel free to contact us via Contact page of this
website
No comments:
Post a Comment