Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 18th 05, 08:06 PM
justin_vasko
 
Posts: n/a
Default 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   Report Post  
Old May 18th 05, 08:16 PM
Alok
 
Posts: n/a
Default

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   Report Post  
Old May 18th 05, 08:21 PM
Barb R.
 
Posts: n/a
Default

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   Report Post  
Old May 18th 05, 08:39 PM
justin_vasko
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
count number of years 2003 in a range of dates Stan Altshuller Excel Worksheet Functions 2 May 3rd 05 07:15 PM
difference between two dates in years, months and days. ruby Excel Worksheet Functions 2 April 4th 05 04:51 PM
Is there a way to calculate business working days between dates i. hjyoungii Excel Worksheet Functions 2 February 23rd 05 04:25 PM
i NEED THE DIFFERENCE OF DATES DOWN TO YEARS...IE 11/1/02-4/16/85. nancelsb Excel Worksheet Functions 1 February 14th 05 02:16 AM
How do I display months and years between two dates JSmith Excel Discussion (Misc queries) 1 November 30th 04 04:41 PM


All times are GMT +1. The time now is 12:00 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017