LearnExcel.io
Menu

Excel Date and Time Functions

This category explores Excel's robust capabilities for working with dates and times, including performing calculations with dates, converting date formats, extracting specific parts of a date, and more.

Page 2 of 13

Excel DATE Function

Learn how to use the Microsoft Excel DATE function to create and manage dates efficiently in your spreadsheets.

April 6, 2024

Excel DATEDIF Function

“Discover how to calculate the difference between two dates easily with the Microsoft Excel DATEDIF function, a versatile and powerful tool for data analysis.”

April 6, 2024

Excel DATEVALUE Function

“Learn how to use the Microsoft Excel DATEVALUE function to convert text to dates, making data analysis easier and more efficient.”

April 6, 2024

Excel DAY Function

Discover the capabilities of the Microsoft Excel DAY Function, a simple way to extract day information from dates, enhancing your data analysis skills.

April 6, 2024

Excel EDATE Function

“Learn how to use the Microsoft Excel EDATE function to easily add or subtract months from a date, with practical examples and tips.”

April 6, 2024

Excel EOMONTH Function

Learn how to master the Microsoft Excel EOMONTH function, a powerful tool for calculating month-end dates efficiently and accurately.

April 6, 2024

Excel HOUR Function

Unlock the potential of time management in Excel with our guide on the Microsoft Excel HOUR Function – your first step to mastering time calculations.

April 6, 2024

Excel ISOWEEKNUM Function

Discover how to use the Microsoft Excel ISOWEEKNUM function to easily calculate the ISO week number of any given date, enhancing your date-time analytics.

April 6, 2024

Excel MINUTE Function

Discover how to use the Microsoft Excel MINUTE function to easily extract minutes from time values in your spreadsheets, enhancing your data analysis.

April 6, 2024

Excel MONTH Function

“Learn how to master the Microsoft Excel MONTH function, an essential tool for extracting month values from dates in your spreadsheets effectively.”

April 6, 2024

Excel NETWORKDAYS Function

“Discover how the Microsoft Excel NETWORKDAYS function can streamline your work by calculating working days between two dates, excluding weekends and holidays.”

April 6, 2024

Excel NETWORKDAYS.INTL Function

Learn how to master the Microsoft Excel NETWORKDAYS.INTL Function to easily calculate workdays between dates, including holidays and weekends.

April 6, 2024

Excel NOW Function

Discover how to master time with the Microsoft Excel NOW Function, a powerful tool for updating the current date and time in your spreadsheets.

April 6, 2024

Excel SECOND Function

Learn how to utilize the Microsoft Excel SECOND function to extract seconds from any date and time value, enhancing your spreadsheet efficiency.

April 6, 2024

Excel TIME Function

Learn how to master the Microsoft Excel TIME function for managing hours, minutes, and seconds effectively in your spreadsheets.

April 6, 2024