I need to calculate column U7.
Here is my statement: =IF(S75,"Mature",S7&" Yrs")
If I run this statement, any record that does not meet this criteria (5)
returns with a serious of digits, e.g. 4505494 in a column U7

The S7 cell icontains a count of years, which is calculated with this
statement: =(DATE(2008,2,3)-P7)/364

What I want to get is:

P7 S7 U7
Open Date Years Opened (full yrs) Maturity
2/24/2005 3 3Yrs
5/9/1997 11 Mature

Please help

Hello Andy,

Just happenned to have done something similar not to long ago. Try using
something along the lines of:

=ROUND(YEARFRAC(P7,Date(2008,2,3),3),0)

for the formula in S7

Thell

I need to calculate column U7.
Here is my statement: =IF(S75,"Mature",S7&" Yrs")
If I run this statement, any record that does not meet this criteria
(5)
returns with a serious of digits, e.g. 4505494 in a column U7
The S7 cell icontains a count of years, which is calculated with this
statement: =(DATE(2008,2,3)-P7)/364

What I want to get is:

P7 S7 U7
Open Date Years Opened (full yrs) Maturity
2/24/2005 3 3Yrs
5/9/1997 11 Mature
Please help