DATEDIF formula enhancement
The response was under Santa-D's post, therefore can easily be construed as
a response to him not you, so there is no reason for you to involve
yourself at all unless you want to.
In response to you, Santa-D then said ...
Thanks Sandy, that worked a treat.
The result comes up as "10 years, 0 months, 0 days" what I was hoping
to do was to have the result display as "10 years" and exclude months &
days as they are equal to 0.
David and I gave him solutions that rounded and only gave years as
requested.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Sandy" wrote in message
ups.com...
Bob Phillips wrote:
required 11 hours before Sandy posted.
What am I getting a row for being late now? <g
Correct me if I am wrong Bob but doesn't your formula only deal with
the OP's specific e? I assumed that he would want to be able to enter
various dates and still get a correct answer.
Regards,
Sandy
Bob Phillips wrote:
Come to think of it, so does David's, so you had two solutions exactly
as
required 11 hours before Sandy posted.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Santa-D" wrote in message
oups.com...
Sandy Mann wrote:
If I follow what you are trying to do try:
=DATEDIF(G7,H7+1,"y") & " years, " & DATEDIF(G7,H7+1,"ym") & "
months, "
&DATEDIF(G7,H7+1,"md") & " days"
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Thanks Sandy, that worked a treat.
The result comes up as "10 years, 0 months, 0 days" what I was hoping
to do was to have the result display as "10 years" and exclude months
&
days as they are equal to 0.
I'm not sure if what I want to do can be done in an excel function
without having to enter into VBA.
Can it be done at all?
|