Remember Me?

#1
May 18th 05, 08:06 PM
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.

#2
May 18th 05, 08:16 PM
 Alok Posts: n/a

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

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.

#3
May 18th 05, 08:21 PM
 Barb R. Posts: n/a

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

Make sure you format C1 as a number.

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.

#4
May 18th 05, 08:39 PM

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.

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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Stan Altshuller Excel Worksheet Functions 2 May 3rd 05 07:15 PM ruby Excel Worksheet Functions 2 April 4th 05 04:51 PM hjyoungii Excel Worksheet Functions 2 February 23rd 05 04:25 PM nancelsb Excel Worksheet Functions 1 February 14th 05 02:16 AM JSmith Excel Discussion (Misc queries) 1 November 30th 04 04:41 PM

All times are GMT +1. The time now is 07:40 AM.