skhanwalker
New Member
- Joined
- Nov 21, 2006
- Messages
- 7
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
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