Showing posts with label Date Function. Show all posts
Showing posts with label Date Function. Show all posts

Sunday, May 10, 2020

Working with Cell referencing (Date Function)

Basic , Date Function
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

Read more »
By at No comments:
Labels: , ,

General Date Function in Excel

Basic , Date Function
General Date Function in Excel

Date function is widely used function in Excel for serving several purposes. Purpose including, creating an invoice for a company, student report card or for a data entry job, you need to work with Dates. So, it is one of the basic things of a learner to know, how to use Date function in Excel.

So, let’s proceed to that,

In brief, Date function makes a legitimate date format of a year, month & day parts and it could combine these individual parts in a single form. And, for creating a large dataset of Dates you need not retype again and again.

This useful function can change Dates dynamically by without effecting other values of existing dataset.

Basic Syntax

= Date (year, month, day)

As you can see from the syntax, Date function passes only three arguments which are year, month & day.
Example

Using this function, you can simply form a valid date by putting values of the individual year, month & day of your own.

Suppose, you want to create a date like 5/9/2020 or  May 9, 2020. You can either create it by manually input the values or by referencing the cells.

Working with manual input

Choose a blank cell and start typing “=Date” and then click on the suggested DATE function, like in the below image,


Then just type the values according to the format of the function and every argument will be separated by a comma. 

Look at the image given here,


Then just press enter of your keyboard. You will get a short date format result within a moment. Like this,


That’s set, isn’t it real quick and simple to manually work with Date function. You can also change this short date format to a long date format. Just go here,


Choose Long Date from the dropdown list,


And, the new result will look like this,


In next tutorial, we will show you, how you can work with Date function by referencing cells. Stay with tutorialabc for more easy and basic Excel tricks & lessons. (TBD) 


Read more »
By at No comments:
Labels: , ,