Calculation of leave days

[Wimpie]

Good Day
Working on Excel 2010
Need a formula to calculate the number of leave days.
C3 - Start Date, e.g. 01/07/2011
D3 - Calculation date, e.g. 31/12/2012
E3 - Number of months - ??????? Forumal need from 01/07/2011 to 31/12/2012
F3 - Days per month, e.g. 1.25
G3 - E3*F3

Please assist

 

[VoG]

Any help?

Excel Workbook
	C	D	E	F	G
3	01/07/2011	31/12/2012	17	1.25	21.25
Sheet4

 

[Wimpie]

Thanx Peter!!! This works Great!!!

 

[Wimpie]

Hi another problem, hope you can help?
If the person started 28/09/2012 how will i calulate this (leave is calulated as 1days leave for every 12 working days -1.25 per month)
I know this person must have 2 days, how do I calulate this, the period should have been from 16/09/2012 till 15/10/2012 (sytem generate this as 0.75 days) and 16/10/2011 till 15/11/2012 (system generate this as 1.25 days.

 

[BengalMagic]

Hi another problem, hope you can help?
If the person started 28/09/2012 how will i calulate this (leave is calulated as 1days leave for every 12 working days -1.25 per month)
I know this person must have 2 days, how do I calulate this, the period should have been from 16/09/2012 till 15/10/2012 (sytem generate this as 0.75 days) and 16/10/2011 till 15/11/2012 (system generate this as 1.25 days.

If start date is in a1, end date is in b1, wouldn't you simply do

=NETWORKDAYS(A1,B1)/12

??

 

[Wimpie]

I tried it and get 3.75, it should be 2

 

[BengalMagic]

I tried it and get 3.75, it should be 2

start date = 28/09/12
end date = 15/11/12

leave = 2.92 days

calculated as 35 working days (assuming Mon-Fri are your working days) so it's simply 35/12?

The calculation is correct.