Scroll To Top

Date Functions of Excel 2016

Posted in Excel11 months ago • Written by Ghulam AbbasNo Comments

Microsoft Excel has too many functions for different fields, and when It comes to date and time functions, it has 23 functions. Today in this lesson I am not performing all of date and time functions, I am Performing only 4 of this functions with step by step guide. For Other Date Functions- Excel 2016, I will cover them in an advanced project with the combination of date and time. I hope you will learn these four basic functions of Excel 2016. So let’s get started.

TODAY function:

Today Function shows today’s date. The best thing about today’s function is, if you save that file, after a month you open it, today ‘s function will give you after a month’s date.  In order to work with it, type this function: =today() Take a look at the screenshot.

Date Functions- Excel 2016

today-function

Now Function:

Now Function shows today’s date and time. It is also the same as today function, if you add anything new in any sheet of excel at the same project, now function will update itself to the current date and time. In order to work it type this function =now(). For better understanding take a look ate the screenshot.

Date Functions- Excel 2016

now-function

Table of Functions:

Date Functions- Excel 2016

table-of-sums

In this table, there is  a date, Sales Representative, and sales. These are given to us, and instead, they want from us to fill the Year, Month, Day, Month Name and Day Name. So let’s start with Year Function.

Year Function:

Year function looks at the date and tells you which year it is. In order to work with it, type this function at the year area to fill them: =Year(Date). After inserting the function it tells you which Year it is. Apply this function at one of them, double click and send that down. For better understanding take a look at the screenshot.

Date Functions- Excel 2016

year-function

Month Function:

MONTH function looks at a date and tells you what month it is. Its functioning is also the same as Year function. The only difference is, it is used as a month.For better understanding take a look at the screenshot.

Date Functions- Excel 2016

month-function

Day Function:

Its functioning is also the same as Year and Month functions. It looks at the date looks at a date and tells you what day it is. For better understanding take a look at the screenshot.

Date Functions- Excel 2016

day-function

Text Function:

Last time in Month function, we found the month by the month function, but now it is time to find the month name. In order to find it, Type this function: =text(Date,”mmmm”).  For better understanding take a look at the screenshot.

Note: “mmmm” converts the number into the month, that’s why I have used.

Date Functions- Excel 2016

text-function

2nd example of Text for day:

I found the month name with text function, although text function isn’t a Date Functions- Excel 2016, but I have used it to take out the month’s name. In order to find the day name type this function: =text(date,”dddd”). For better understanding take a look at the screenshot.

Note: “dddd” converts the number into the day, that’s why I have used.

Date Functions- Excel 2016

day-name

Conclusion 

It was all about, Date Functions- Excel 2016. I hope you have learned this article, I hope you will ask your questions, give us your suggestions, opinion about what articles we have to write. If you faced any problem tell us below by comment, Feel free to tell us. we’re waiting for your suggestion.

Watch out the Clip:

TAGS: , , , , , ,

Leave A Response