I am using the following formula (gained from a previous community entry, thanks guys) =IFERROR(NETDAYS([Construction quote date]@row, TODAY()), 0)
it is calculating the number days between a quote date column and today's date.
however I want to fix the number of days when the actual close date is entered into a cell column called 'Actual Close date' or similar creating a permanent record thereafter of the number of days for a specific job row from quote date to close date.
I can't seem to fine a problem that is similar and just not quite sure how to set out to solve.
I have included screen shots
The Number days to sell is showing 121 ( between 12/3/19 and todays date) I have however added the actual sell date 12/6/19 in the actual close date column, and in that circumstance I would like that sell days to change to the difference betwee 12/3/19 and 12/6/19.
any suggestions ?
Ok reading further clearly the 'today" formula wont work as a long term solution so I need to create another column but would welcome suggestions