Leave balance Carry Forward

[uswyne]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Month[/TD]
[TD]Emp #[/TD]
[TD]Opening Casual Leave[/TD]
[TD]Availed Casual Leave[/TD]
[TD]Casual Leave Balance [/TD]
[/TR]
[TR]
[TD]Sep 18[/TD]
[TD]1[/TD]
[TD]05[/TD]
[TD]01[/TD]
[TD]04 =(C1-D1)[/TD]
[/TR]
[TR]
[TD]Sep 18[/TD]
[TD]2[/TD]
[TD]07[/TD]
[TD]02[/TD]
[TD]05 =(C2-D2)[/TD]
[/TR]
[TR]
[TD]Oct 18[/TD]
[TD]1[/TD]
[TD]04 ? auto fill[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Oct 18[/TD]
[TD]2[/TD]
[TD]05 ? auto fill[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

how to opening casual leave auto fill while entering new month payroll?

 

[James006]

Hello,

You can have the following Array Formula in cell C4

=INDEX($E$2:$E$10,MATCH(EDATE(A4,-1)&B4,$A$2:$A$10&$B$2:$B$10,0))

Hope this will help

 

[uswyne]

its not working looking for any solution.

 

[uswyne]

Its done, i forgot to pres Alt+Shift+Enter, Thanks for you help

Hello,

You can have the following Array Formula in cell C4

=INDEX($E$2:$E$10,MATCH(EDATE(A4,-1)&B4,$A$2:$A$10&$B$2:$B$10,0))

Hope this will help

 

[James006]

You are welcome ...

Glad you could fix your problem ...

 

[uswyne]

while I am adding more month i.e. Nov-18, Dec-18, formula does not work.

 

[James006]

Hello,

Rather strange ...

Is your actual layout different than the one described in your first message ...?

 

[uswyne]

actually this is payroll tempalte, i am using table in which every month payroll in same sheet. for example i have 10 employee so after every 10 rows there is a new month and it is for a whole year.

Hopefully I can make u understand.

Hello,

Rather strange ...

Is your actual layout different than the one described in your first message ...?

 

[uswyne]

lay out is the same

 

[uswyne]

Kindly add Nov and Dec in Coloumn A and Emp # in Column B

actually this is payroll tempalte, i am using table in which every month payroll in same sheet. for example i have 10 employee so after every 10 rows there is a new month and it is for a whole year.

Hopefully I can make u understand.