Friday, January 22, 2021
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

How to aggregate named groups of GL accounts.

How to Report GL Account Groups in Excel

Believe it or not, this income statement is quite sophisticated. It's not nearly as simple-minded as it looks. In fact, this income statement illustrates a...
If you want all your Excel reports, analyses, forecasts, and other Excel work to be highly productive, this is the only strategy that will work for you.

An Introduction to Excel Data Plumbing

Would you like to: Create your new reports, analyses, forecasts, and other Excel work quickly? Update your Excel work with one command, without using...
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...
Advertisement
Advertisement