Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate Number of years
I am trying to calcualte number of years an employee has been with the
company from today's date. I can't seem to find a formula that will help me with that. Also, I need a formula that will calculate 75 workdays from date of hire. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate Number of years
One way:
Number of years: A1: <start date B1: =DATEDIF(A1,TODAY(),"y") See http://cpearson.com/excel/datedif.htm for more on DATEDIF() 75 Workdays: =WORKDAY(A1,75) Requires the Analysis Toolpak Add-in for pre-XL07/08. See XL Help for details. In article , Needs Help wrote: I am trying to calcualte number of years an employee has been with the company from today's date. I can't seem to find a formula that will help me with that. Also, I need a formula that will calculate 75 workdays from date of hire. Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate Number of years
If you have a hire date in A1, then this formula in B1 will give you
the number of years: =(TODAY()-A1)/365.25 Format the cell as General, or as Number with 2 dp. To get 75 days after a hire date which is in A2, use this: =A2+75 Format this cell as a date. Hope this helps. Pete On Dec 7, 3:02 pm, Needs Help wrote: I am trying to calcualte number of years an employee has been with the company from today's date. I can't seem to find a formula that will help me with that. Also, I need a formula that will calculate 75 workdays from date of hire. Thanks! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate Number of years
If you only want the calendar days just use
=TODAY()-start e.g. a1 holds the start date 08/12/1995 =TODAY()-A1 format as general will return the days, if you want years look here http://www.cpearson.com/excel/datedif.aspx will look like =DATEDIF(A1,TODAY(),"y") -- Regards, Peo Sjoblom "Needs Help" wrote in message ... I am trying to calcualte number of years an employee has been with the company from today's date. I can't seem to find a formula that will help me with that. Also, I need a formula that will calculate 75 workdays from date of hire. Thanks! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate Number of years
=DATEDIF(Start_date,TODAY(),"Y")
=WORKDAY(DoH,75) if you define a set of holiday dates in a range, you can also include that =WORKDAY(DoH,75,holidays) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Needs Help" wrote in message ... I am trying to calcualte number of years an employee has been with the company from today's date. I can't seem to find a formula that will help me with that. Also, I need a formula that will calculate 75 workdays from date of hire. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate the number of years between 2 dates | Excel Discussion (Misc queries) | |||
Calculate number of years and months employed using hire date and. | Excel Worksheet Functions | |||
Function to calculate the number of years, months and days between | Excel Worksheet Functions | |||
HOW TO CALCULATE THE NUMBER OF YEARS BETWEEN TWO DATES | Excel Worksheet Functions | |||
calculate number of years | New Users to Excel |