Here are some tips for using the Excel DATEDIF or NETWORKDAYS function:
Choose the appropriate function for your needs. DATEDIF will give you the time difference between two dates while NETWORKDAYS will give you the number of weekdays between two dates.
Determine what parameters to use. DATEDIF needs three parameters: start date, end date, and interval. NETWORKDAYS only needs two parameters: start date and end date.
Enter the date format you want the output to be in. DATEDIF needs the output to be in a month-day-year format. NETWORKDAYS will output a number.
Sometimes you may need to alter the dates given so that they fit the parameters. For example, if you need the number of days between two dates and one date is in the future, you may need to use dates in the past to get meaningful output.
