Sunday, October 25, 2020
This table summarizes the performance of Excel's worksheet functions primarily designed to work with dates

Overview of Excel’s Date Functions

At last count, Excel 365 offers 25 worksheet functions that return date or time information. The links are to the Microsoft help topics for each...
Here are nineteen examples of common date calculations used in Excel reports and analyses, using worksheet functions like DATE, EDATE, EOMONTH, and others.

Nineteen Date Calculations in Excel

Excel reports and analyses typically include date calculations. But many Excel users have large gaps in their knowledge about this topic. So in this article,...
With the help of three functions most Excel users seldom use -- INT, MOD, and CEILING -- you can round Excel time values to any increment you want.

How to Round Time in Excel to Any Increment

Several years ago, a reader asked whether it's possible to use the ROUND function to round times quarter- or half-hour increments. I gave him a...

Latest Articles

Here's how to boost your Excel output, slash your Excel errors, and improve your Excel reports and analyses—whether you work for a large or small company.

How to Be Significantly More Productive in Excel

The Excel charts below are professional-quality. But that's not what makes them so unusual. Instead... ● You can update them in a few seconds, with...
Use this Excel dashboard to track 27 economic indicators of the United States' recovery from the Covid-19 recession.

Learn How to Use Excel to Track the US Recovery from the Covid Recession

The Covid recession is the worst recession the world has experienced since the Great Depression. And the Recovery Tracker workbook and Excel training can...
This Excel dashboard report lets you follow key economic trends while showing you how to gain a HUGE increase in your Excel productivity at work.

Track Key Economic Indicators Every Weekday with this Excel Dashboard

You can update this Excel dashboard report every weekday—with one command—if you have Excel 2016 or above. This report of current economic data introduces you...
Advertisement
Advertisement