Featured Formulas

Calculate time before expiration date

In this example, the goal is to calculate the time remaining before an expiration date. There are many ways to do something like this in Excel, and in this article, we'll look at three different approaches:

  1. Calculating the remaining time in days
  2. Calculating the remaining
  3. ...Read more

Featured Functions

NETWORKDAYS Function

The NETWORKDAYS function returns the number of working days between two dates, automatically excluding weekends (Saturday and Sunday) and optionally excluding holidays provided as a list of dates. NETWORKDAYS can be used to calculate employee benefits that accrue...Read more

Recent Articles

Your site is GREAT and so refreshing compared to the rest of the stuff out there on Excel. The writing and explanations are clear, concise, and to the point!
Jeff
I just leaned over to tell my colleague that any time I have a question on how to execute something in excel, I type my topic into google with "Exceljet" in the search and my answer is right there waiting for me. It is an incredible service and sometimes I feel like I am able to ask you my questions directly since the material is thorough, very well presented, and so easy for me to understand.
Kevin
I just wanted to say how much of resource you've created. With Exceljet I've been able to automate a budgeting issue which, without hyperbole, has not been done in approximately 50yrs in my niche industry. No one simply put in the time to realize it could all be 1s and 0s. And with your site, I've been able to guide myself how to do exactly that.
John

Get Training

We offer free resources and paid training.

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed.

View Paid Training & Bundles

Just show me the free stuff

Excel 101 and Core Pivot Packages