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

EXCEL FUNCTIONS-TIMEVALUE

INTRODUCTION TIMEVALUE FUNCTION returns the decimal equivalent of given TIME [given as Text] in EXCEL. TIMEVALUE FUNCTION is a function …
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

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

EXCEL FUNCTIONS-DATEVALUE

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

EXCEL FUNCTIONS-DATEDIF

INTRODUCTION DATEDIF FUNCTION is a DATE BASED function present in Excel.It is specially kept in Excel to support the older …
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