Formula Help - Displaying "days" after

[jmacavali]

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?

[Jonmo1]

Check for custom formatting of the original cell.
Try copying the original cell, then paste special / formats onto the new formula cell.

[dilipandey]

Hi jmacavali,

welcome to the forum.
Try copying pasting as format from the cell first cell to second cell


Regards,
DILIPandey
<click on below * if this helps>

[jmacavali]

BINGO! Thanks for the quick help and reply. As soon as you mentioned that I remembered setting it up with the custom format (quite a few months ago ). Thanks again.



EDIT:
Rep to Jonmo1 as his was first and I was typing this reply when dilipandey's reply showed up.

[dilipandey]

No problem


Please mark this thread as [SOLVED]..

3 cheers to Jonmo1


Regards,
DILIPandey
<click on below * if this helps>

[Jonmo1]

Glad to help, thanks for the feedback.

[jmacavali]

No problem


Please mark this thread as [SOLVED]..

3 cheers to Jonmo1


Regards,
DILIPandey
<click on below * if this helps>

I was looking for the quick link to do that...I found it though under thread tools...kind of burried for newbies to go looking when I'm only stopping in for a quick question. Anyway...it's marked.

[dilipandey]

kind of burried for newbies to go looking when I'm only stopping in for a quick question

New users will be new for every forum unless they stop and take some rest & learn


Regards,
DILIPandey
<click on below * if this helps>