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:
=NETWORKDAYS(date,date) ie: =NETWORKDAYS(C8,C9)

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

For more excel techniques see our Excel Training Class.