Prev: How do I export a Pivot Table in Excel into Word?
Next: from the text 4 pcs., how to remove only characters/text
From: S on 24 May 2010 09:59
I am looking for a formula that would calculate the difference in dates but
display in weeks-can this even be done?

Col A
Date Received
4/15/2010


Col B
Approx Age in Weeks
2

I am trying to calculate the current age in weeks but cannot come up with
the right formula. The closest I could get was using TODAY() but kept
getting the errors. I have the formatting for the results col. set as number
with 0 decimals.
Thank you in advance for any assistance!
From: Luke M on 24 May 2010 10:13
=INT((TODAY()-A2)/7)

or

=ROUND((TODAY()-A2)/7)

--
Best Regards,

Luke M
"S" <S(a)discussions.microsoft.com> wrote in message
news:1B6DE8CB-AFA2-48B2-A37C-55682072AC3D(a)microsoft.com...
>I am looking for a formula that would calculate the difference in dates but
> display in weeks-can this even be done?
>
> Col A
> Date Received
> 4/15/2010
>
>
> Col B
> Approx Age in Weeks
> 2
>
> I am trying to calculate the current age in weeks but cannot come up with
> the right formula. The closest I could get was using TODAY() but kept
> getting the errors. I have the formatting for the results col. set as
> number
> with 0 decimals.
> Thank you in advance for any assistance!



From: Niek Otten on 24 May 2010 10:17
=(TODAY()-A2)/7

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"S" <S(a)discussions.microsoft.com> wrote in message
news:1B6DE8CB-AFA2-48B2-A37C-55682072AC3D(a)microsoft.com...
>I am looking for a formula that would calculate the difference in dates but
> display in weeks-can this even be done?
>
> Col A
> Date Received
> 4/15/2010
>
>
> Col B
> Approx Age in Weeks
> 2
>
> I am trying to calculate the current age in weeks but cannot come up with
> the right formula. The closest I could get was using TODAY() but kept
> getting the errors. I have the formatting for the results col. set as
> number
> with 0 decimals.
> Thank you in advance for any assistance!

From: S on 25 May 2010 09:14
Works perfectly! Thank you so much - it was the /7 that I was missing... DUH!

"Niek Otten" wrote:

> =(TODAY()-A2)/7
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "S" <S(a)discussions.microsoft.com> wrote in message
> news:1B6DE8CB-AFA2-48B2-A37C-55682072AC3D(a)microsoft.com...
> >I am looking for a formula that would calculate the difference in dates but
> > display in weeks-can this even be done?
> >
> > Col A
> > Date Received
> > 4/15/2010
> >
> >
> > Col B
> > Approx Age in Weeks
> > 2
> >
> > I am trying to calculate the current age in weeks but cannot come up with
> > the right formula. The closest I could get was using TODAY() but kept
> > getting the errors. I have the formatting for the results col. set as
> > number
> > with 0 decimals.
> > Thank you in advance for any assistance!
>
 | 
Pages: 1
Prev: How do I export a Pivot Table in Excel into Word?
Next: from the text 4 pcs., how to remove only characters/text