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!

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!

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!

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!