working with dates in fiscal years

[Guest]

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!

 

[Guest]

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

 

[Guest]

A1 - 2004-11-24
B1 = 2005-03-31
C1 = B1-A1

Make sure you format C1 as a number.

 

[Guest]

thanks for the help!
much appreciated!

A1 - 2004-11-24
B1 = 2005-03-31
C1 = B1-A1

Make sure you format C1 as a number.