Calculate age for specific date + 3 months

[sowhat]

Hello,

I need to calculate the age of people 3 months and 1 year after a specific date (and the specific date varies just like DOB).

So something like this:

Age = age upto the specific date + 3 months

and Age = age upto the specific date + 1 year

Can someone help me with this if I have DOB in A1 and specific dates in A2. I understand that I can calculate age upto the specific date by going =DATEDIF(A1,A2,"y"). How do I add 3 months and 1 year to this?

 

[t0azt]

Can it be ((A2-A1)/365)+(90/365) for the three months and ((A2-A1)/365)+1 for the year?

 

[robertdseals]

for the year, could you do =(DATEDIF(A21,B21,"y"))+1

 

[sowhat]

Hi! Thankyou so much! That's perfect!!

 

[robertdseals]

And for the month.
=((DATEDIF(A21,B21,"m"))+3)/12

 

[Latchmaker]

For an exact date not just plus 3 month or plus 1 year use these formulas

Where A1 is DOB and B1 is Specific Date

<style type="text/css">
table.tableizer-table {
border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif
font-size: 12px;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #ccc;
}
.tableizer-table th {
background-color: #104E8B;
color: #FFF;
font-weight: bold;
}
</style><table class="tableizer-table">
<tr class="tableizer-firstrow"><th>B1 + 3 Months</th><th>B1 +3 Months Age</th><th>B1 +1 Year</th><th>B1 + 1 Year Age</th></tr>
<tr><td>=DATEVALUE(CONCATENATE(IF(MONTH(B1)>9,MONTH(B1)-9,SUM(MONTH(B1)+3)),"/",DAY(B1),"/",IF(IF(MONTH(B1)>9,MONTH(B1)-9,SUM(MONTH(B1)+3))<MONTH(B1),YEAR(B1)+1,YEAR(B1))))</td><td>=DATEDIF(A1,DATEVALUE(CONCATENATE(IF(MONTH(B1)>9,MONTH(B1)-9,SUM(MONTH(B1)+3)),"/",DAY(B1),"/",IF(IF(MONTH(B1)>9,MONTH(B1)-9,SUM(MONTH(B1)+3))<MONTH(B1),YEAR(B1)+1,YEAR(B1)))),"y")</td><td>=DATEVALUE(CONCATENATE(MONTH(B1),"/",DAY(B1),"/",YEAR(B1)+1))</td><td>=DATEDIF(A1,DATEVALUE(CONCATENATE(MONTH(B1),"/",DAY(B1),"/",YEAR(B1)+1)),"y")</td></tr>
</table>

 

[sowhat]

Thanks everyone! You have all been very helpful!