I am trying to convert one formula for calculating age into a different formula for calculating age.
For instance:
- In cell A1, I have the following formula: =DATEDIF("8/21/1995",TODAY(),"Y") which returns a value of 27.
- In cell B1, I have the following formula: =FORMULATEXT(A1), which returns a value of =DATEDIF("8/21/1995",TODAY(),"Y")
- In cell C1, I have the following custom formula: =AGEDECIMAL(B1), which returns a value of =ROUNDDOWN(YEARFRAC(DATE(1995,8,21),TODAY(),1),1)
How would I use the value of cell C1 as the formula for cell D1?
I have tried searching around for solutions online and I think I may need to use the INDIRECT function, but I'm still unsure of the syntax required.
