# 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 FUNCTIONS-WEEKDAY

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

#### EXCEL FUNCTIONS-TIMEVALUE

INTRODUCTION TIMEVALUE FUNCTION returns the decimal equivalent of given TIME [given as Text] in EXCEL. TIMEVALUE FUNCTION is a function …

#### 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

INTRODUCTION DAY function comes under the DATE AND TIME FUNCTIONS category in Excel. DAY FUNCTION returns the DAY NUMBER(1 TO …

#### EXCEL FUNCTIONS-DATEVALUE

INTRODUCTION DATEVALUE function comes under the DATE AND TIME FUNCTIONS category in Excel. DATEVALUE FUNCTION function converts a date in …

#### EXCEL FUNCTIONS-DATEDIF

INTRODUCTION DATEDIF FUNCTION is a DATE BASED function present in Excel.It is specially kept in Excel to support the older …

#### EXCEL FUNCTIONS-DATE

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