Sunday, May 10, 2020

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.

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) 

No comments:

Post a Comment