OMG, I have been reading through a lot of the question and answers (great
forum) and this one shocked me. Susan, she was not professional at all. But I
loved your reply. Keep helping us dough heads! Thanks

"Susan" wrote:

well, you're right - i apologize for getting frustrated with your lack
of explanation. but as rick said, also, it's very hard to offer any
help when nobody understands what's going on.
susan


On Dec 24, 6:50 pm, Janice Reid wrote:

I ask for help not mouth
--
Janice



"Susan" wrote:
business problems don't usually come with detailed instructions and
hints. therefore, i'm assuming this is homework.

you've got the formula right in front of you, you only need to put in
the cell references for where the two dates are......
* Tenure = (Today's date - Hire Date)/365

=(thecellthatholdstoday'sdate-thecellthatholdsthehiredate)/365

signed, the grinch

On Dec 24, 3:16 pm, Janice Reid wrote:
--
Janice

"Susan" wrote:
how would you do it on a calculator?? (i have no idea how to
"calculate tenure".)
:)
if you can explain how you'd do it on a calculator (like 2 + 2 = 4)
and what cells "2" is in, and where you want "4", then i can give you
the formula (probably).
susan

On Dec 24, 1:32 pm, Janice Reid wrote:
--
Janice
I need to Create a formula that calculates the employees tenure in years. In
cell G7
But I'm having trouble I don't understand how to do this.

# In cell G7, create a formula that calculates the employee's tenure in years. (Don't worry that the result will look odd; we'll take care of that in the next step.)

* Tenure = (Today's date - Hire Date)/365

# Format the formula result as Number, 2 decimal places.
# Use the fill handle to copy the formula from cell G7 down to the last
employee. Make sure you absolute any cell references that need it! (Hint: The
result in cell G7 should be 9.98, the tenure in cell G26 should be 4.46.)- Hide quoted text -

- Show quoted text -

I ask for help not mouth- Hide quoted text -

- Show quoted text -