NETDAYS Function

Returns the number of days from a start date to an end date.
Sample Usage
NETDAYS([Due Date]4, [Due Date]5)
Syntax
NETDAYS(
  • start_date
  • end_date
)
  • start_date
    The first date that you want to be measured.
  • end_date
    The last date that you want to be measured.
Examples

This example references the following sheet information:

  Clothing Item Transaction Total Units Sold Sold Date
1 T-Shirt 1,170.00 78 02/12/19
2 Pants 1,491.00 42 02/15/19
3 Jacket 812.00 217 02/20/19

Given the table above, here are some examples of using NETDAYS in a sheet:

Formula Description Result
=NETDAYS([Sold Date]1, [Sold Date]2) Returns the number of days from the start date in the “Sold Date” column on row 1 to the end date in “Sold Date” on row 2. 4
=NETDAYS(MAX([Sold Date]:[Sold Date]), TODAY())

Returns the number of days from the most recent date in the “Sold Date” column to the current date. (The current date in this example being May 31st, 2019.)

Note that the TODAY function updates as the current date change.

101
=NETDAYS(MIN([Sold Date]:[Sold Date]), MAX([Sold Date]:[Sold Date])) Returns the number of days from the oldest date in the “Sold Date” column, to the most recent date in the “Sold Date” column. 9