Need help with a formula

J

JJ

Need to calculate the number of years an employee has worked. I'd like to use
the Today() function as an absolute reference in the formula. I also want to
divide the difference by the number of days in a year.
 
M

Mike H

I don't understand the last bit but with the DES in a1 try this

=DATEDIF(A1,TODAY(),"y")&" Years "&DATEDIF(A1,TODAY(),"yM")&" Months
"&DATEDIF(A1,TODAY(),"md")&" Days"

Mike
 
N

Niek Otten

Look here:

http://www.cpearson.com/excel/datedif.aspx

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Need to calculate the number of years an employee has worked. I'd like to use
| the Today() function as an absolute reference in the formula. I also want to
| divide the difference by the number of days in a year.
| --
| jj
 

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

Expanding Date formula 1
Excel Formula - Count Dates from another Sheet 8
Countif Formula 1
If formula with dates 4
vacation accrual formula 2
Help on formula - 2
Calculating Averages based on criteria 6
Help with formula 4

Top