how do I subtract years and then divide

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to subtract date hired from today's date and then divide the
difference by 365
 
try this where cell a15 contains the date hired.

=(today()-a15)/365
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to subtract a number from a Mergefield? 0
subtract and divide 1
Hello happy new year to all, Text box input for year of purchase 0
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
Seniority Years Formula needed 5
How to migrate Gmail to Office 365? 2
Date Formula 6
Need help asap 3

Back
Top