Number of days

Question

I have two fields- &nbsp;estimated completion date and date completed. &nbsp;I am trying to create a formula to populate the number of days to complete the project ONLY if date completed is null. &nbsp;I can create the formula and make it work if I leave out the completed part, put am getting an error when trying to incorporate the completed field.------------------------------Angela Bowman------------------------------

markshnier__you · Answer

Can you post your current formula?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

angelabowman · Answer

If(not IsNull([Date completed]),"",ToDays([Estimated completion date]-Today()))------------------------------Angela Bowman------------------------------

angelabowman · Answer

I got it... &nbsp;never mind! thanks.------------------------------Angela Bowman------------------------------

Forum Discussion

Number of days

3 Replies