Velocity Reviews > Excel formula help

# Excel formula help

John
Guest
Posts: n/a

 04-02-2005
Hello.

I don't supposed anyone knows how to display a decimal number in excel
in years and months to the nearest month?

For example, I may have the figure 6.75. We know it should be 6 years
and 9 months, but how do I get excel to display it like that?

I am guessing I may need to use the DATEIF function?

Thanks for any help

John

John
Guest
Posts: n/a

 04-02-2005
On Sat, 02 Apr 2005 10:53:28 +0100, A strange species called John
<(E-Mail Removed)> wrote:

>Hello.
>
>I don't supposed anyone knows how to display a decimal number in excel
>in years and months to the nearest month?
>
>For example, I may have the figure 6.75. We know it should be 6 years
>and 9 months, but how do I get excel to display it like that?
>
>I am guessing I may need to use the DATEIF function?
>
>Thanks for any help
>
>John

Its okay. Worked this one out now. Quite a toughie.

John

Buckaroo Banzai
Guest
Posts: n/a

 04-02-2005

"John" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Sat, 02 Apr 2005 10:53:28 +0100, A strange species called John
> <(E-Mail Removed)> wrote:
>
>>Hello.
>>
>>I don't supposed anyone knows how to display a decimal number in excel
>>in years and months to the nearest month?
>>
>>For example, I may have the figure 6.75. We know it should be 6 years
>>and 9 months, but how do I get excel to display it like that?
>>
>>I am guessing I may need to use the DATEIF function?
>>
>>Thanks for any help
>>
>>John

>
> Its okay. Worked this one out now. Quite a toughie.
>
> John
>

Too bad... you'd for sure have gotten the right answer tuit suite
considering you posted the question to a Howard Stern NG....

Buckaroo Banzai
Guest
Posts: n/a

 04-02-2005
Sorry! I thought I was in the Howard Stern NewsGroup... my bad!

"Buckaroo Banzai" <(E-Mail Removed)> wrote in message
news:N8x3e.8326\$(E-Mail Removed) ...
>
> "John" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> On Sat, 02 Apr 2005 10:53:28 +0100, A strange species called John
>> <(E-Mail Removed)> wrote:
>>
>>>Hello.
>>>
>>>I don't supposed anyone knows how to display a decimal number in excel
>>>in years and months to the nearest month?
>>>
>>>For example, I may have the figure 6.75. We know it should be 6 years
>>>and 9 months, but how do I get excel to display it like that?
>>>
>>>I am guessing I may need to use the DATEIF function?
>>>
>>>Thanks for any help
>>>
>>>John

>>
>> Its okay. Worked this one out now. Quite a toughie.
>>
>> John
>>

>
> Too bad... you'd for sure have gotten the right answer tuit suite
> considering you posted the question to a Howard Stern NG....
>
>
>
>
>

*
Guest
Posts: n/a

 04-02-2005
Hi Buckaroo Banzai, You told me:
> "Buckaroo Banzai" <(E-Mail Removed)> wrote in message
> news:N8x3e.8326\$(E-Mail Removed) ...
>>
>> "John" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> On Sat, 02 Apr 2005 10:53:28 +0100, A strange species called John
>>> <(E-Mail Removed)> wrote:
>>>
>>>> Hello.
>>>>
>>>> I don't supposed anyone knows how to display a decimal number in
>>>> excel in years and months to the nearest month?
>>>>
>>>> For example, I may have the figure 6.75. We know it should be 6
>>>> years and 9 months, but how do I get excel to display it like that?
>>>>
>>>> I am guessing I may need to use the DATEIF function?
>>>>
>>>> Thanks for any help
>>>>
>>>> John
>>>
>>> Its okay. Worked this one out now. Quite a toughie.
>>>
>>> John
>>>

>>
>> Too bad... you'd for sure have gotten the right answer tuit suite
>> considering you posted the question to a Howard Stern NG....

> Sorry! I thought I was in the Howard Stern NewsGroup... my bad!

BWAHAHAHAHAHAHAHAHAHAA! You ****tard ****.

John
Guest
Posts: n/a

 04-02-2005
On Sat, 02 Apr 2005 13:31:25 GMT, A strange species called "Buckaroo
Banzai" <(E-Mail Removed)> wrote:

>
>"John" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed).. .
>> On Sat, 02 Apr 2005 10:53:28 +0100, A strange species called John
>> <(E-Mail Removed)> wrote:
>>
>>>Hello.
>>>
>>>I don't supposed anyone knows how to display a decimal number in excel
>>>in years and months to the nearest month?
>>>
>>>For example, I may have the figure 6.75. We know it should be 6 years
>>>and 9 months, but how do I get excel to display it like that?
>>>
>>>I am guessing I may need to use the DATEIF function?
>>>
>>>Thanks for any help
>>>
>>>John

>>
>> Its okay. Worked this one out now. Quite a toughie.
>>
>> John
>>

>
>Too bad... you'd for sure have gotten the right answer tuit suite
>considering you posted the question to a Howard Stern NG....

I'm not completely sure on this joke as I'm British, but I guess it
would be an insult. I'm sure that Stern guy is a liberal talk radio
host in America isn't he? He's the one with long scruffy hair right?
And he supported flip-flop Kerry in the election? If so, yep, if I was
a regular tech-advisor in here I'd be insulted by that

John

Buckaroo Banzai
Guest
Posts: n/a

 04-02-2005

"*" <*@*.*> wrote in message
news:(E-Mail Removed)...
> Hi Buckaroo Banzai, You told me:
>> "Buckaroo Banzai" <(E-Mail Removed)> wrote in message
>> news:N8x3e.8326\$(E-Mail Removed) ...
>>>
>>> "John" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> On Sat, 02 Apr 2005 10:53:28 +0100, A strange species called John
>>>> <(E-Mail Removed)> wrote:
>>>>
>>>>> Hello.
>>>>>
>>>>> I don't supposed anyone knows how to display a decimal number in
>>>>> excel in years and months to the nearest month?
>>>>>
>>>>> For example, I may have the figure 6.75. We know it should be 6
>>>>> years and 9 months, but how do I get excel to display it like that?
>>>>>
>>>>> I am guessing I may need to use the DATEIF function?
>>>>>
>>>>> Thanks for any help
>>>>>
>>>>> John
>>>>
>>>> Its okay. Worked this one out now. Quite a toughie.
>>>>
>>>> John
>>>>
>>>
>>> Too bad... you'd for sure have gotten the right answer tuit suite
>>> considering you posted the question to a Howard Stern NG....

>
>> Sorry! I thought I was in the Howard Stern NewsGroup... my bad!

>
> BWAHAHAHAHAHAHAHAHAHAA! You ****tard ****.

Hey, when I mess up, I mess up- so for today, I *am* a '****tard ****'.....

Buckaroo Banzai
Guest
Posts: n/a

 04-02-2005

"John" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Sat, 02 Apr 2005 13:31:25 GMT, A strange species called "Buckaroo
> Banzai" <(E-Mail Removed)> wrote:
>
>>
>>"John" <(E-Mail Removed)> wrote in message
>>news:(E-Mail Removed). ..
>>> On Sat, 02 Apr 2005 10:53:28 +0100, A strange species called John
>>> <(E-Mail Removed)> wrote:
>>>
>>>>Hello.
>>>>
>>>>I don't supposed anyone knows how to display a decimal number in excel
>>>>in years and months to the nearest month?
>>>>
>>>>For example, I may have the figure 6.75. We know it should be 6 years
>>>>and 9 months, but how do I get excel to display it like that?
>>>>
>>>>I am guessing I may need to use the DATEIF function?
>>>>
>>>>Thanks for any help
>>>>
>>>>John
>>>
>>> Its okay. Worked this one out now. Quite a toughie.
>>>
>>> John
>>>

>>
>>Too bad... you'd for sure have gotten the right answer tuit suite
>>considering you posted the question to a Howard Stern NG....

>
> I'm not completely sure on this joke as I'm British, but I guess it
> would be an insult. I'm sure that Stern guy is a liberal talk radio
> host in America isn't he? He's the one with long scruffy hair right?
> And he supported flip-flop Kerry in the election? If so, yep, if I was
> a regular tech-advisor in here I'd be insulted by that
>
> John

Aww, the joke's on me John... I thought I clicked into the Howard Stern NG..
but it was Alt.computer... So I blasted what I thought was a computer
question in a HS forum... I'm an idiot!

Dr. Bill
Guest
Posts: n/a

 04-02-2005
Buckaroo Banzai wrote:
> I *am* a '****tard ****'.....

Nice sig!

* * * Y o u r . S h e p h e r d . A q u i l a . D e u s . ( d 2 0 0 5 x x , d 2 0 0 4
Guest
Posts: n/a

 04-02-2005

Dr. Bill wrote:
> Buckaroo Banzai wrote:
> > I *am* a '****tard ****'.....

>
> Nice sig!

--
hmmmm... dumb...