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”)