Sunday, May 10, 2020

Working with Cell referencing (Date Function)

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