0
I want to calculate days on wait list (0 if the assessment date column is not filled in), calculate date from today minus the referral received date, and then stop the calculation when the date of assessment is added.
I have this formula which nicely counts the days on wait list, but I want it to stop when the client has been assessed...how do I do this?
Formula:
=IF(ISBLANK(G7),0,DATEDIF(G7,TODAY(),"d"))
Referral received is G4
, assessment date is L4
where is your formula in H7? – yass – 2017-05-02T19:46:54.327