Calculate amount of time between two dates but also include an IF
System
Employee Admin
This discussion was created from comments split from: Formula to calculate the amount of time between two dates.
Answers

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.

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,
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!