Date Difference

[SK]

I need to calculate the monthly salary based on the start
and end date of an appointment and the total salary, say
Start=2003/9/1, End=2003/12/19, Total Salary = $3000.
What is the best way to calculate it? I've tried using
DateDiff ("m", [Start], [End]) but the result is not
accurate.

Help is greatly appreciated.

 

[Ian]

-----Original Message-----
I need to calculate the monthly salary based on the start
and end date of an appointment and the total salary, say
Start=2003/9/1, End=2003/12/19, Total Salary = $3000.
What is the best way to calculate it? I've tried using
DateDiff ("m", [Start], [End]) but the result is not
accurate.

Help is greatly appreciated.
.

Reply,

I think that the problem here might be is the First and
Last months not being whole months. One suggestion might
be is to ingore the first and last month and then do
calculation.

Another suggestion might be to find the weekly amount
that multi by 52 and divide by 12. (Or go to days even)

Hope this helps Ian

 

[John Vinson]

I need to calculate the monthly salary based on the start
and end date of an appointment and the total salary, say
Start=2003/9/1, End=2003/12/19, Total Salary = $3000.
What is the best way to calculate it? I've tried using
DateDiff ("m", [Start], [End]) but the result is not
accurate.

Help is greatly appreciated.

DateDiff("m"... is indeed accurate: it calculates the number of whole
integer months between the dates. To be precise the number of month
boundaries crossed; e.g. DateDiff("m", #1/31/2004#, #2/1/2004#) is 1.

I would guess that a salary calculation for partial months would
involve working days. How would you calculate it on paper, if someone
were to work for (say) ten days, or forty days?