Excel Formulas

[jmacavali]

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?

 

[jmacavali]

There is a custom format you can use that will add 'days' to the end of whatever is in the cell. Since it had been many months since I did the first column I had forgotten all about it. Found it and it's good now.

 

[strollin]

Glad you found it and thanks for posting the solution!

 

[BK_123]

I hate using formulas in Excel :/

 

[setishock]

I've made several spread sheets to ease the paperwork here at the hotel. Formulas are fairly straight forward when doing the less complicated stuff like payroll and the daily reports.
The macros are what blows my mind.