Featured Formulas

Date and Time

Calculate retirement date

To calculate a retirement date based on a birthdate, you can use the EDATE function. In the example shown, the formula in D6 is: =EDATE(C6,12*60) The result is a date 60 years (720 months) from the date of birth in column C. Note: At the time of this …Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Date and time

WORKDAY Function

The Excel WORKDAY function returns a date in the future or past that is a given number of working days from a specified start date, excluding weekends and (optionally) holidays. You can use the WORKDAY function to calculate things like start dates, delivery dates, and completion dates that need to …Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

Oh, and some feedback - you are the best Excel learning resource on the web.
Ron
I basically spend all day, every day, in Excel for my work. When I see your website pop up with an answer to my question, I ALWAYS select it first. In fact, I look for exceljet.net option FIRST, hoping your website pops up with a solution for me. I absolutely love the way you explain things. It is easy to follow your instruction and you offer BOTH written instruction as well as video.
LBM
Your suggestion of using array constants with the SORT function hadn't occurred to me and it solved a tricky problem I was grappling with quickly and cleanly. I haven't seen it suggested anywhere else, and it is a very powerful and effective way to use the SORT array function on multiple criteria - hats off to you, sir, and many thanks.
Henry
More Testimonials

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