Home |
Search |
Today's Posts |
#1
|
|||
|
|||
working with dates in fiscal years
i am trying to calculate the percentage of the year that someone has been
employed with my company. for example, they began on 2004-11-24, and i am trying to use formula tro calculate the number of days they are employed from that date until 2005-03-31. i have been using the DATE() function, but am getting less than satisfactory results i am wondering if there is a way to calculate the number of days between one specified date and another. thanks for all your help! |
#2
|
|||
|
|||
Assuming start date is in A1 and End Date is in B1, Use the following formula
=(B1-A1)/(B1-DATE(YEAR(B1)-1,MONTH(B1),DAY(B1))) Just remember to format the Cell as Percentage. Alok Joshi "justin_vasko" wrote: i am trying to calculate the percentage of the year that someone has been employed with my company. for example, they began on 2004-11-24, and i am trying to use formula tro calculate the number of days they are employed from that date until 2005-03-31. i have been using the DATE() function, but am getting less than satisfactory results i am wondering if there is a way to calculate the number of days between one specified date and another. thanks for all your help! |
#3
|
|||
|
|||
A1 - 2004-11-24
B1 = 2005-03-31 C1 = B1-A1 Make sure you format C1 as a number. "justin_vasko" wrote: i am trying to calculate the percentage of the year that someone has been employed with my company. for example, they began on 2004-11-24, and i am trying to use formula tro calculate the number of days they are employed from that date until 2005-03-31. i have been using the DATE() function, but am getting less than satisfactory results i am wondering if there is a way to calculate the number of days between one specified date and another. thanks for all your help! |
#4
|
|||
|
|||
thanks for the help!
much appreciated! "Barb R." wrote: A1 - 2004-11-24 B1 = 2005-03-31 C1 = B1-A1 Make sure you format C1 as a number. "justin_vasko" wrote: i am trying to calculate the percentage of the year that someone has been employed with my company. for example, they began on 2004-11-24, and i am trying to use formula tro calculate the number of days they are employed from that date until 2005-03-31. i have been using the DATE() function, but am getting less than satisfactory results i am wondering if there is a way to calculate the number of days between one specified date and another. thanks for all your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count number of years 2003 in a range of dates | Excel Worksheet Functions | |||
difference between two dates in years, months and days. | Excel Worksheet Functions | |||
Is there a way to calculate business working days between dates i. | Excel Worksheet Functions | |||
i NEED THE DIFFERENCE OF DATES DOWN TO YEARS...IE 11/1/02-4/16/85. | Excel Worksheet Functions | |||
How do I display months and years between two dates | Excel Discussion (Misc queries) |