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

EXCEL FUNCTION- DAYS

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

EXCEL FUNCTIONS-WEEKDAY

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

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: …
Read More

EXCEL FUNCTION-TIME

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

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 …
Read More

EXCEL FUNCTIONS-NETWORKDAYS

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

EXCEL FUNCTIONS-DAY

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

EXCEL FUNCTIONS-DATEVALUE

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

EXCEL FUNCTIONS-DATEDIF

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

EXCEL FUNCTIONS-DATE

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