Computer Forums Excel Formulas
 Register FAQ Members List Calendar Search Today's Posts Mark Forums Read Log in

 Thread Tools Search this Thread Display Modes

 05-16-2013, 07:29 AM #1 Fully Optimized     Join Date: Jun 2009 Posts: 4,867 Excel Formulas 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? __________________ __________________ **************************************** Don't take life too seriously -- no one gets out alive. Plus, who wants to arrive to the hereafter in pristine condition wearing a suit and tie? I want to slide in sideways, worn out, used up, hair a mess, clothes tattered, & screaming, "Whooo! What a ride!" ****************************************
 05-16-2013, 08:02 AM #2 Fully Optimized     Join Date: Jun 2009 Posts: 4,867 Re: Excel Formulas 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. __________________ __________________ **************************************** Don't take life too seriously -- no one gets out alive. Plus, who wants to arrive to the hereafter in pristine condition wearing a suit and tie? I want to slide in sideways, worn out, used up, hair a mess, clothes tattered, & screaming, "Whooo! What a ride!" ****************************************
 05-16-2013, 08:47 AM #3 Fully Optimized     Join Date: Mar 2011 Location: USA Posts: 2,379 Re: Excel Formulas Glad you found it and thanks for posting the solution! __________________
 05-17-2013, 07:18 AM #4 Golden Master     Join Date: Dec 2009 Location: Australia Posts: 7,557 Re: Excel Formulas I hate using formulas in Excel :/ __________________
 05-17-2013, 08:24 AM #5 Wizard of Wires     Join Date: Feb 2005 Location: Not sure Posts: 10,030 Re: Excel Formulas 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. __________________

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules