trainee1032
01-12-2015, 09:02 PM
Hello,
I was hoping someone could help me out with and If/Then formula:
I need a formula that will tell me if a birth date that is entered in Cell B1 is between the age 12-24 months of age in the years 8/01/2009 to 12/31/2012. For Example, someone who was born 11/01/2008 was between 12-24 months in the years 2009-2012 therefore the value should return a YES in Cell B2. If the child was under 12 months or over 24 months the Cell value will be no.
Also in Cell D4 a value should return a Yes if in Cell B1 and Cell B2 has two birth dates and both were under 6 years old in the years 8/01/2009 up to 12/31/2012. For Example, in cell B1 the birth date was entered 11/1/2005 and in cell B2 the birth date that was entered is 8/1/2004 so the Value in cell D4 should be yes. If both children were not under 6 years old then the cell value will be No.
Hopefully someone can help me out,
Thank you
I was hoping someone could help me out with and If/Then formula:
I need a formula that will tell me if a birth date that is entered in Cell B1 is between the age 12-24 months of age in the years 8/01/2009 to 12/31/2012. For Example, someone who was born 11/01/2008 was between 12-24 months in the years 2009-2012 therefore the value should return a YES in Cell B2. If the child was under 12 months or over 24 months the Cell value will be no.
Also in Cell D4 a value should return a Yes if in Cell B1 and Cell B2 has two birth dates and both were under 6 years old in the years 8/01/2009 up to 12/31/2012. For Example, in cell B1 the birth date was entered 11/1/2005 and in cell B2 the birth date that was entered is 8/1/2004 so the Value in cell D4 should be yes. If both children were not under 6 years old then the cell value will be No.
Hopefully someone can help me out,
Thank you