Leave balance Carry Forward

[uswyne]

Month	Emp #	Opening Casual Leave	Availed Casual Leave	Casual Leave Balance
Sep 18	1	05	01	04 =(C1-D1)
Sep 18	2	07	02	05 =(C2-D2)
Oct 18	1	04 ? auto fill
Oct 18	2	05 ? auto fill

<tbody>
</tbody>

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.