No. of days from a calculation

[skhanwalker]

Hello.

I have a column in which I stored calculated values (difference between dates). However, when I update the date in another column, I change the value to "closed". Now, I have a new requirement. I need to know what was that value when I update the date. I tried using ABS function, but that cause a #VALUE to appear the moment I update the date because there is no value. Here is what it looks like:

Review Date Planned Closure Date Date Closed Number of days open No. of Days to Close

Under planned closure date, I have the formula: =IF(ISBLANK(G840)," ",(G840+30))

Under number of days open I have the formula: =IF(A840="","",IF(I840="",NOW()-G840,"Closed"))

I now to know the number of days the transaction was open even after it has been closed, so that I can do aging analysis.

Thanks in advance

 

[adept]

Why not just have the Number of Open Days a up to the minute calculation with Now(), by comparing if Closed is less than Now()? If Closed then it will show the Number of Days open.

Craig

 

[skhanwalker]

Thanks very much. I used the following formulae:

In the column, no. of days open currently: =IF(C5="",NOW()-A5,"Closed")

In the column no. of days to close: =IF(C5="", "",C5-A5)

 

[adept]

Glad I could help. Good luck.

Craig