Calculate duration with a decimal

HI Jeffrey,

I'd use DATEDIF to calculate the number of Days between your birthdate and TODAY. Dividing the number of days by 365.25 will give you a more precise result than counting weeks and dividing by 25.

Here are the results, at 17 day intervals, for the age in years of a person born January 1, 2000.

Formula in C2: DATEDIF(A2,B2,"D")

Formula in D2: C2÷365.25

For the example, both are filled down to the last row in the column.

For your finished version, using only cells A2, B2 and C2, use these :

A2: enter your birthdate

B2: enter as a formula: TODAY()

C2: DATEDIF(A2,B2,"D")/365.25

Set the Data Format for C2 as shown above for column D of the example, but set the Decimals stepper to 1.

Regards,

Barry

HI again,

Regarding automatic updating—TODAY (and other functions) won't do that without being nudged.

If you close the document each day, then open it the next, the action of opening the document will trigger the recalculation.

Annother was is to make the DATADIF formula dependent on the setting of a checkbox cell. You could tell TODAY to calculate when the checkbox is 'true' (checked) or tell it to calculate when the checkbox is 'false' (unchecked). Either of thise would require two clicks to trigger the recalculation.

To reduce that to a single click, set up your formula to calculate on both conditions, effectively triggering the recalculation whenever the cell's setting is changed.

Checkbox in D2, formula in C2.

C2: IF(D2,DATEDIF(A2,B2,"D")/365.25,DATEDIF(A2,B2,"D")/365.25)

Regards,

Barry