service date

[Pammy]

If I have a hire date of August 1985 and today's date is April 30th, how do
you create a formula that will give me a continuous service date?

 

[Bernard Liengme]

Have a look at Chip's use of DATEDIFF (www.cpearson.com)
best wishes