If you want to calculate the difference between 2 dates in Excel, you have to use a hidding function . It's the function DATEDIF.
This step-by-step guide will explain to you how to build a birthday reminder in Excel with a specific color when the event occurs
Calculate seniority is an easy task with Excel when you use the appropriate function.
This article gives you the M Code for Power Query to return the result of the DATEDIFF function (difference between 2 dates)