Formula to calculate variance in years between 2 dates? Like NETYEARS perhaps?

Kimberley D. Smith

I'm simply trying to calculate the number of years between 2 dates. I didn't see any simple solution. Any guidance would be appreciated. Thank you.

Bassam Khalil

Hi @Kimberley D. Smith ,

hope you are fine, please use the following formula

=YEAR2@row - YEAR@row

Best Regards

Bassam Khalil

Hi @Kimberley D. Smith ,

hope you are fine, please use the following formula

=YEAR2@row - YEAR@row

Best Regards

Kimberley D. Smith

Perfect, @Bassam.M Khalil! Thank you so very much for the assistance! 😀

Bassam Khalil

Most Welcome,

at your service any time.