Using DatedIf and information from Cells

[techchef]

I would like to use the =DATEDIF(“Date1”,“Date2”,“y”) function, but i would like it to automatically pull Date1 from Cell (lets just say) J2…and Date2 From K2. Is this possible?

[LeroyG]

@techchef

Is this possible?

Hello @techchef,
Yes, it is. =DATEDIF(J2;K3;"y"). Don’t be afraid to try.

[techchef]

@LeroyG

=DATEDIF(J2;K3;“y”)

Thank You, Thank You, Thank You! You saved me about 10 hours work!

[LeroyG]

You’re welcome!
Happy to hear that it helped you so much.