Days Lapsed/Column Formula

Ashley Pierce

How do I create a Column Formula that will calculate how many days have lapsed since the "Issue Start Date"? I currently have the formula: =SUM(TODAY() - [Issue Start Date]1) but when I try to convert it to a Column Formula, it states it's not quite right to convert. Any suggestions?

Mike Wilday

You'll want to use either Net Days or Net Work Days depending on whether you want calendar days (Net Days) or Business Days (Net workdays). Here are the formulas you should use.

=Netdays([Issue Start Date]@row, Today())

=Networkdays([Issue Start Date]@row, Today())

Mike Wilday

You'll want to use either Net Days or Net Work Days depending on whether you want calendar days (Net Days) or Business Days (Net workdays). Here are the formulas you should use.

=Netdays([Issue Start Date]@row, Today())

=Networkdays([Issue Start Date]@row, Today())