I have a formula that determines a child's age by the month. I noticed
that today 9/16 one of our children turned 1 month old but the answer
still says 0. What is wrong with formula.
It would be nice if I had one formula instead of two. THe formula can
calculate age up to 6 weeks, the in months from 2 months up to 35
months, and then 3 years and up. Can anyone help me?

This is the formula I use for the months
=IF(C87="","",ROUNDDOWN(((TODAY()-C87)/365*12),0))''=


This is the formula I use for the 3 year olds and higher.
=IF(ROUNDDOWN(((TODAY()-B9)/365*12),0)=37,ROUNDDOWN(((TODAY()-B9)/
365*12),0),ROUNDDOWN(((TODAY()-B9)/365),0))

It would be nice to have one formula to calculate all scenarios.

See this:

http://www.cpearson.com/Excel/datedif.aspx

--
Biff
Microsoft Excel MVP


"Debbie" wrote in message
...
I have a formula that determines a child's age by the month. I noticed
that today 9/16 one of our children turned 1 month old but the answer
still says 0. What is wrong with formula.
It would be nice if I had one formula instead of two. THe formula can
calculate age up to 6 weeks, the in months from 2 months up to 35
months, and then 3 years and up. Can anyone help me?

This is the formula I use for the months
=IF(C87="","",ROUNDDOWN(((TODAY()-C87)/365*12),0))''=


This is the formula I use for the 3 year olds and higher.
=IF(ROUNDDOWN(((TODAY()-B9)/365*12),0)=37,ROUNDDOWN(((TODAY()-B9)/
365*12),0),ROUNDDOWN(((TODAY()-B9)/365),0))

It would be nice to have one formula to calculate all scenarios.

On Oct 16, 10:42*pm, "T. Valko" wrote:
See this:

http://www.cpearson.com/Excel/datedif.aspx

--
Biff
Microsoft Excel MVP

"Debbie" wrote in message

...



I have a formula that determines a child's age by the month. I noticed
that today 9/16 one of our children turned 1 month old but the answer
still says 0. * What is wrong with formula.
It would be nice if I had one formula instead of two. THe formula can
calculate age up to 6 weeks, the in months from 2 months up to 35
months, and then 3 years and up. Can anyone help me?

This is the formula I use for the months
=IF(C87="","",ROUNDDOWN(((TODAY()-C87)/365*12),0))''=

This is the formula I use for the 3 year olds and higher.
=IF(ROUNDDOWN(((TODAY()-B9)/365*12),0)=37,ROUNDDOWN(((TODAY()-B9)/
365*12),0),ROUNDDOWN(((TODAY()-B9)/365),0))

It would be nice to have one formula to calculate all scenarios.- Hide quoted text -

- Show quoted text -

is there a code for weeks? year = "y", month = "m", day = "d". What is
weeks.

No code for weeks.

You can just subtract the birth date from today's date then divide by 7.

A1 = birth date

=(TODAY()-A1)/7

--
Biff
Microsoft Excel MVP


"Debbie" wrote in message
...
On Oct 16, 10:42 pm, "T. Valko" wrote:
See this:

http://www.cpearson.com/Excel/datedif.aspx

--
Biff
Microsoft Excel MVP

"Debbie" wrote in message

...



I have a formula that determines a child's age by the month. I noticed
that today 9/16 one of our children turned 1 month old but the answer
still says 0. What is wrong with formula.
It would be nice if I had one formula instead of two. THe formula can
calculate age up to 6 weeks, the in months from 2 months up to 35
months, and then 3 years and up. Can anyone help me?

This is the formula I use for the months
=IF(C87="","",ROUNDDOWN(((TODAY()-C87)/365*12),0))''=

This is the formula I use for the 3 year olds and higher.
=IF(ROUNDDOWN(((TODAY()-B9)/365*12),0)=37,ROUNDDOWN(((TODAY()-B9)/
365*12),0),ROUNDDOWN(((TODAY()-B9)/365),0))

It would be nice to have one formula to calculate all scenarios.- Hide
quoted text -

- Show quoted text -

is there a code for weeks? year = "y", month = "m", day = "d". What is
weeks.

On Oct 17, 12:18*am, "T. Valko" wrote:
No code for weeks.

You can just subtract the birth date from today's date then divide by 7.

A1 = birth date

=(TODAY()-A1)/7

--
Biff
Microsoft Excel MVP

"Debbie" wrote in message

...
On Oct 16, 10:42 pm, "T. Valko" wrote:





See this:

http://www.cpearson.com/Excel/datedif.aspx

--
Biff
Microsoft Excel MVP

"Debbie" wrote in message

....

I have a formula that determines a child's age by the month. I noticed
that today 9/16 one of our children turned 1 month old but the answer
still says 0. What is wrong with formula.
It would be nice if I had one formula instead of two. THe formula can
calculate age up to 6 weeks, the in months from 2 months up to 35
months, and then 3 years and up. Can anyone help me?

This is the formula I use for the months
=IF(C87="","",ROUNDDOWN(((TODAY()-C87)/365*12),0))''=

This is the formula I use for the 3 year olds and higher.
=IF(ROUNDDOWN(((TODAY()-B9)/365*12),0)=37,ROUNDDOWN(((TODAY()-B9)/
365*12),0),ROUNDDOWN(((TODAY()-B9)/365),0))

It would be nice to have one formula to calculate all scenarios.- Hide
quoted text -

- Show quoted text -

is there a code for weeks? year = "y", month = "m", day = "d". What is
weeks.- Hide quoted text -

- Show quoted text -


So I get that, but I don't understand how I can make the formula
determine my criteria
=(TODAY()-C87)/7
C87 is DOB
I want it to be IF(c87<8 weeks,then formula to calculate weeks, if(and
(c877 wks,c87<24 mo),"then formula to calculate months), if(c8723
months, then formula to calculate years)

I checked out DATEDIF but that does not calculate weeks. Can anyone
please help me with this formula. It needs to calculate daily. The
formula I had, did not calculate daily. Thanks!