Days Lapsed/Column Formula
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?
Best Answer
-
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())
Answers
-
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())
Help Article Resources
Categories
Check out the Formula Handbook template!