| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with a formula
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with a formula
Look he
http://www.cpearson.com/excel/datedif.aspx -- Kind regards, Niek Otten Microsoft MVP - Excel "JJ" wrote in message ... | 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with a formula
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 "JJ" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with a formula
DES stands for ? Date of employee service??
-- jj "Mike H" wrote: 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 "JJ" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with a formula
sorry Date entered service
"JJ" wrote: DES stands for ? Date of employee service?? -- jj "Mike H" wrote: 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 "JJ" wrote: 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with a formula
If you want the number of years, use the DATEDIF function.
http://www.cpearson.com/excel/datedif.aspx -- David Biddulph "JJ" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
