Excel Functions

How to Use Excel YEAR Function?

Excel Year Function TL;DR The YEAR function extracts the year from a valid date in Excel. The basic syntax is:…

Read More »

How to Use Excel WEEKNUM Function?

Excel WEEKNUM Function TL;DR The WEEKNUM function returns the week number of a specific date, based on the year. The…

Read More »

How to Use Excel NETWORKDAYS.INTL Function?

Using NETWORKDAYS.INTL Function in Excel TL;DR The NETWORKDAYS.INTL function returns the number of working days between two dates, with customizable…

Read More »

How to Use Excel NOW Function?

Examples of using NOW Function in Excel TL;DR The NOW() function returns the current date and time based on your…

Read More »

How to Use Excel NETWORKDAYS Function?

Basic usage of Excel NETWORKDAYS Function TL;DR The NETWORKDAYS function calculates the number of working days between two dates, automatically…

Read More »

How to Use Excel MONTH Function?

Examples of using Excel MONTH Function TL;DR The MONTH function extracts the month as a number (1–12) from a given…

Read More »

How to Use Excel MINUTE Function?

Example of Using Excel MINUTE Function TL;DR The MINUTE function extracts the minute component and returns a numerical value from…

Read More »

How to Use Excel DAYS360 Function?

Example of using Excel DAYS360 function TL;DR The DAYS360 function calculates the number of days between two dates based on…

Read More »

How to Use Excel TIMEVALUE Function?

Using Excel TIMEVALUE Function TL;DR The TIMEVALUE function converts a time written as text (like “1:30 PM“) into a decimal…

Read More »

How to Use Excel WEEKDAY Function?

Excel WEEKDAY Function WEEKDAY Function: A Brief The Excel WEEKDAY Function is used to return a number representing the day…

Read More »