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 3 of 13

Excel TIMEVALUE Function

Discover how to effortlessly convert text to a time value with the Microsoft Excel TIMEVALUE function, enhancing your data analysis skills.

April 6, 2024

Excel TODAY Function

Learn how the Microsoft Excel TODAY Function can dynamically update your spreadsheets with the current date, making your work more efficient.

April 6, 2024

Excel WEEKDAY Function

Learn how to use the Microsoft Excel WEEKDAY function to easily identify days of the week in your data sheets and improve your date-related calculations.

April 6, 2024

Excel WEEKNUM Function

Discover how the Microsoft Excel WEEKNUM function can simplify your date-related analyses by easily calculating the week number of any given date.

April 6, 2024

Excel WORKDAY Function

Discover the power of Microsoft Excel WORKDAY Function to easily calculate workdays and streamline project timelines in our comprehensive guide.

April 6, 2024

Excel WORKDAY.INTL Function

Learn how the WORKDAY.INTL function in Microsoft Excel customizes workdays, bypassing weekends and holidays in your project planning.

April 6, 2024

Excel YEAR Function

Unlock the power of time with our guide on the Microsoft Excel YEAR Function, perfect for extracting the year from any date in your spreadsheets.

April 6, 2024

Excel YEARDIF Function

“Discover how to use the Microsoft Excel YEARDIF Function effectively to calculate the difference between two dates in years, enhancing your spreadsheets.”

April 6, 2024

Excel YEARFRAC Function

Discover how to use the Microsoft Excel YEARFRAC function to accurately calculate the fractional difference in years between two dates.

April 6, 2024

How to Add Axis Titles in Excel

Learn how to add axis titles in Excel and improve the readability of your charts. Follow our step-by-step guide to easily add axis titles to your charts.

May 21, 2023

How to Add a Border in Excel

Learn how to add a border to your Excel spreadsheet with our simple step-by-step guide. Customize your borders to make your data stand out!

May 21, 2023

How to Add a Bullet in Excel

Learn how to add a bullet in Excel with our comprehensive step-by-step guide. Improve the visual appeal of your data and streamline your spreadsheets today!

May 21, 2023

How to Add a Calendar in Excel

Learn how to add a calendar in Excel and keep track of important dates and deadlines! Our step-by-step guide will show you how to use the built-in calendar function and customize it to your needs.

May 21, 2023

How to Add Cells Together in Excel

Learn how to add cells together in Excel with this easy-to-follow guide. From basic formulas to more advanced calculations, we’ve got you covered.

May 21, 2023