Nesting

Nesting is the technique of placing one formula or function inside another.

The idea is that one function requires a value that can be delivered by another.

The start date is provided by cell C4.

YEARFRAC returns a decimal value like this in D4:

which is passed directly to the INT function.

The INT function removes the decimal portion of the number and returns 18 as a final result.

More examples of nesting

Nesting is a common technique in more advanced Excel formulas.

Here are a few more examples: