Leave availed report

[pallu]

Hi

Im attached the report of leave availed, there two sheet 1st sheet if any one taken the leave within limit i have mentioned the Policy. based on that restrict the leave.

second sheet contains leave balance to adjust the leave availed and shown the balance if no leave marked as abscent

Pls help me for cell restrication and balance leave based on the formula

Regards
Pallu

 

[pallu]

pls help

 

[pallu]

hi

Pls help me out for formual

 

[Faseeh]

Hi pallu

There are two sheets which one do you want to work on??

 

[pallu]

1st sheet

 

[Faseeh]

Let me try it, will revert with Q&A.

 

[Faseeh]

Hi pallu,

Do you want data validation in Col J and L of first sheet. I mean you want a fix so that no one can enter more then 3 in Col J and more then 2 in Col L?

Do you wan similar validation for CL/PL so that if a cell contains value for SL one can not enter a value in corresponding CL/PL.

 

[pallu]

yes

 

[Faseeh]

Please see attachment.

 

[pallu]

Hi

thanks it works i need other calculation leave balance i have mentioned the contditon Pls help
regards
pallu

 

[pallu]

hi
Pls help

 

[Deepak]

hi
Pls help

@ pallu,

You should to have patience as @Faseeh might be celebrating ramjan.
So, Stay tuned & he will revert upon heading here!!

 

[Faseeh]

@pallu,

Sorry for keep you waiting, sometime i am unable to spare time from my office work.

 

[Faseeh]

@pallu,

1. Where is Pl in your sheet, you have SL, EL, CL, LOP not PL!
2. Why SL is negative? If there are no SL then it should be zero (Cell M3)

 

[Faseeh]

Please see sheet2 for the solution.

 

[pallu]

hi thanks for your effort

if employoee have leave balance in Sl only 4 day but he has taken 6days then leave should adjust to Earned leave only same wise CL

 

[Faseeh]

@pallu,

have you checked the attachment i have worked out same pattern in it.