MICROSOFT EXCEL FUNCTIONS- DATE AND TIME

DATE AND TIME FUNCTIONS

DATE AND TIME group of functions contain very important and widely used functions in Excel.

Managing Date and Time in Excel and using them efficiently is very challenging if you don’t know the basics of these two very important dimensions. Date and time are common parts of any report which we have to create using Excel.

Here is the list of functions which fall under this category. Click the function for its further details i.e. formula syntax, examples, purpose etc.

DATE AND TIME FUNCTIONS

HOW TO USE NOW FUNCTION IN EXCEL?

Table of Contents INTRODUCTION PURPOSE OF NOW FUNCTION IN EXCEL WHAT IS THE SYNTAX OF NOW FUNCTION IN EXCEL? USAGE …

EXCEL FUNCTION- DAYS

INTRODUCTION DAYS function comes under the DATE AND TIME FUNCTIONS category in Excel. Handling the dates in Excel is a …

EXCEL FUNCTIONS-WEEKDAY

INTRODUCTION WEEKDAY FUNCTION comes under the DATE AND TIME FUNCTIONS CATEGORY of functions in Excel. WEEKDAY FUNCTION simply returns the …

FIND THE DECIMAL VALUE OF TIME USING TIMEVALUE FUNCTION IN EXCEL

Table of Contents INTRODUCTION PURPOSE OF TIMEVALUE FUNCTION IN EXCEL PREREQUISITES TO LEARN TIMEVALUE FUNCTION SYNTAX OF TIMEVALUE FUNCTION EXAMPLE: …

EXCEL FUNCTION-TIME

INTRODUCTION TIME FUNCTION comes under the DATE AND TIME FUNCTIONS category in Excel. TIME FUNCTION simply returns the decimal equivalent …

EXCEL FUNCTIONS-NETWORKDAYS.INTL

INTRODUCTION NETWORKDAYS.INTL function comes under the DATE AND TIME FUNCTIONS category in Excel. NETWORKDAYS.INTL FUNCTION simply returns number of working …

EXCEL FUNCTIONS-NETWORKDAYS

INTRODUCTION NETWORKDAYS function comes under the DATE AND TIME FUNCTIONS category in Excel. NETWORKDAYS FUNCTION simply returns number of working …

EXCEL FUNCTIONS-DAY

Table of Contents INTRODUCTION PURPOSE OF DAY FUNCTION IN EXCEL PREREQUISITES TO LEARN DAY FUNCTION SYNTAX: DAY FUNCTION EXAMPLE: DAY …

EXCEL FUNCTIONS-DATEVALUE

Table of Contents INTRODUCTION PURPOSE OF DATEVALUE FUNCTION IN EXCEL PREREQUISITES TO LEARN DATEVALUE SYNTAX: DATEVALUE FUNCTION EXAMPLE: DATEVALUE IN …

EXCEL FUNCTIONS-DATEDIF

Table of Contents INTRODUCTION PURPOSE OF DATEDIF FUNCTION IN EXCEL PREREQUISITES TO LEARN DATEDIF FUNCTION SYNTAX: DATEDIF FUNCTION IN EXCEL …

EXCEL FUNCTIONS-DATE

INTRODUCTION DATE function comes under the DATE AND TIME FUNCTIONS category in Excel. DATE FUNCTION simply returns the date as …