# Microsoft Excel

## [EXCEL] – FORMULA REFERENCES

WHAT ARE FORMULA REFERENCES IN MICROSOFT EXCEL? Formula references in Microsoft Excel are when we create a simple formula or a formula that uses a function, you can refer to data in worksheet cells by including cell references in the formula arguments. For example, when… Read More »[EXCEL] – FORMULA REFERENCES

## [EXCEL] – NETWORKDAYS.INTL FUNCTION

WHAT IS NETWORKDAYS.INTL FUNCTION IN MICROSOFT EXCEL? NETWORKDAYS.INTL function released in Microsoft Excel 2010. Have you got a query why Microsoft released new function similar to neworkdays? In NETWORKDAYS function by default it treats Saturday and Sunday as weekends, and we can’t change. But, what… Read More »[EXCEL] – NETWORKDAYS.INTL FUNCTION

## [EXCEL] – NETWORKDAYS FUNCTION

WHAT IS NETWORKDAYS FUNCTION IN MICROSOFT EXCEL? In Microsoft Excel, NETWORKDAYS function is used return the whole number of working days (business days) between two dates. Working days exclude weekends and days identified as holidays. By default, NETWORKDAYS function exclude Saturday and Sunday as weekends… Read More »[EXCEL] – NETWORKDAYS FUNCTION

## [EXCEL] – WEEKNUM FUNCTION

WHAT IS WEEKNUM FUNCTION IN MICROSOFT EXCEL? In Microsoft Excel, WEEKNUM function returns the week number of a specific date, return value is integer, and it is between 1 to 54 (depends on return type selection). For example, the week containing January 1 is the… Read More »[EXCEL] – WEEKNUM FUNCTION

## [EXCEL] – WEEKDAY FUNCTION IN MICROSOFT EXCEL

WHAT IS WEEKDAY FUNCTION IN MICROSOFT EXCEL? WEEKDAY function in Microsoft Excel, helps us to find the day number of the week corresponding to a date. By default, the return value is between 1 (Sunday) to 7 (Saturday) . SYNTAX OF WEEKDAY FUNCTION WEEKDAY function… Read More »[EXCEL] – WEEKDAY FUNCTION IN MICROSOFT EXCEL

## [EXCEL] – FORMAT CELLS IN MICROSOFT EXCEL

WHAT IS FORMAT CELLS IN MICROSOFT EXCEL? Format cells in Microsoft Excel helps us to formatting cell types, alignment, font changes, adding or removing borders, protecting cells, and fill cells background colors. HOW TO FORMAT CELLS IN MICROSOFT EXCEL In Microsoft Excel, we can format… Read More »[EXCEL] – FORMAT CELLS IN MICROSOFT EXCEL

## [EXCEL] – EDATE and EOMONTH FUNCTIONS

WHAT IS EDATE AND EOMONTH FUNCTIONS IN MICROSOFT EXCEL EDATE and EOMONTH functions in Microsoft Excel returns the serial number that represents the date based on date and months selection. If we use EDATE function to calculate maturity dates or due dates that fall on… Read More »[EXCEL] – EDATE and EOMONTH FUNCTIONS

## [EXCEL] – DATEDIF FUNCTION IN MICROSOFT EXCEL

WHAT IS DATEDIF FUNCTION IN MICROSOFT EXCEL? DATEDIF function in Microsoft Excel helps us to get difference of 2 dates in years or month or days. DATEDIF function is available from earlier of excel versions i.e. from excel 97 version. Microsoft removed this function in… Read More »[EXCEL] – DATEDIF FUNCTION IN MICROSOFT EXCEL

## [EXCEL] – DATE FUNCTION IN MICROSOFT EXCEL

WHAT IS DATE FUNCTION IN MICROSOFT EXCEL? In Microsoft Excel, DATE function helps to return date value by using day, month and year values from different cells. Date function in Microsoft Excel is more powerful function, and this function is categorized under Date and Time… Read More »[EXCEL] – DATE FUNCTION IN MICROSOFT EXCEL

## [Excel]- Day, month, year functions

WHAT IS DAY, MONTH, AND YEAR FUNCTIONS IN EXCEL? In Microsoft Excel, DAY,MONTH, and YEAR functions helps us to extract day value or month value or year value from a date. Day, Month, and Year functions requires one functional argument i.e. date value. SYNTAX FOR… Read More »[Excel]- Day, month, year functions