Excel – Useful Date Calculations - AdvantEdge Training & Consulting

Excel – Useful Date Calculations

Date formulas can always be challenging when working with Excel. Here are 3 that can be very useful when trying to calculate days or months between 2 dates, or to display the date as the day of the week in a text format.
Calculating days of the week in Excel:

To identify what day of the week a specific date falls on:
TEXT(Value, Format_Text) ie: =TEXT(C15,”dddd”)

Calculating # of workdays between 2 dates in Excel:

Calculating # of months, days or years between 2 dates in Excel:
DATEDIF(Value, Value, Format) ie: =DATEDIF(C8,C9,”m”)


For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top