Calculate days between two dates if the date is greater than 01/01/2024

tchav
tchav ✭✭✭✭
edited 04/05/24 in Formulas and Functions

Hello,


I am trying to grab the number of dates between two dates if the manufacture date is greater than 01/01/24. This is the formula I am using and it is not working.

=IF([Manufacture Date]@row, >DATE(2024, 1, 1), [Paperwork/HPLC]@row - [Manufacture Date]@row, 0)

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!