jmacavali
Fully Optimized
- Messages
- 4,867
I might have to go to an excel forum, but thought I'd try here first.
I have this formula:
=IF([@IMAGED]<>"",TODAY()-[@IMAGED],"")
where it looks at the "imaged" column and then figures out how long it's been since the computer was imaged. The result in the column is "xx days".
I copied the formula to another column and changed 2 words:
=IF([@PURCHASED]<>"",TODAY()-[@PURCHASED],"")
so that I could do the same thing to calculate how long it's been since the computer was purchased. The result in the column is "xx". What's missing is the word "days".
I have no idea where it comes from in the first formula and why it doesn't show up in the second. Any thoughts anyone?
I have this formula:
=IF([@IMAGED]<>"",TODAY()-[@IMAGED],"")
where it looks at the "imaged" column and then figures out how long it's been since the computer was imaged. The result in the column is "xx days".
I copied the formula to another column and changed 2 words:
=IF([@PURCHASED]<>"",TODAY()-[@PURCHASED],"")
so that I could do the same thing to calculate how long it's been since the computer was purchased. The result in the column is "xx". What's missing is the word "days".
I have no idea where it comes from in the first formula and why it doesn't show up in the second. Any thoughts anyone?