I want to calculate the number of days using two date fields, and if blank use today.

Danielle Maroon

I want to calculate the Days to Build field by counting the number of days from the Ready for Customer QA minus the Build Start Date. And if there is no date in Ready for Customer QA I want to know how many days from today - Build Start Date

Kelly Moore

Hey @Danielle Maroon

Try this. The formula first checks to see if [Ready for Customer QA] is a date. If yes, the two column dates are subtracted. If no, TODAY() is used as one variable.

=IF(ISDATE([Ready for Customer QA]@row, [Ready for Customer QA]@row-[Build Start Date]@row, TODAY()-[Build Start Date]@row)

Will this work for you?

Kelly

Kelly Moore

Hey @Danielle Maroon

Try this. The formula first checks to see if [Ready for Customer QA] is a date. If yes, the two column dates are subtracted. If no, TODAY() is used as one variable.

=IF(ISDATE([Ready for Customer QA]@row, [Ready for Customer QA]@row-[Build Start Date]@row, TODAY()-[Build Start Date]@row)

Will this work for you?

Kelly