Calculate amount of time between two dates but also include an IF

System

This discussion was created from comments split from: Formula to calculate the amount of time between two dates.

Kristin Rankin

How do you calculate the amount of time between two dates but also include an IF? For example, I want to calculate the amount of time between two dates but only specific to a particular column of data. In this case it is the duration for negotiating a Master Agreement with the Agreement type included in a separate column.

Kelly Moore

Hey @Kristin Rankin

Give this a try and then we can tweak with more details.

=IF([whatever your column name]@row="Whatever agreement type", NETWORKDAY([your start date]@row, [your end date]@row))

This formula will return the number of working days between the two dates. If you want total days, replace NETWORKDAY with NETDAYS (the difference in plural and singular is intentional).

cheers,