Need help on Leave Planner template formula

[hemanthcrpatna]

Hi there,

I'm creating a new leave planner for my team and I have followed one template and created half of the it and now struck up use the dashboard formula which can update the data by referring the data sources.

I would need help on using the below formula

IF(A6<>"",IF(E$5>TODAY(),"",IF(E5="","",IF(AND(COUNTIF(DATE,E$5)>0,E$5<>""),"H",IF(OR(E$4="Sat",E$4="Sun"),"W/O",IFERROR(VLOOKUP($A6&" "&E$5,Data!$A:$E,5,0),"P"))))),"")

Here is the template that I created
https://www.dropbox.com/s/kqu4uw783sbkrjv/Leave Planner-2017.xlsx?dl=0

Here's the template which I'm following
https://www.dropbox.com/s/l0oi038nka8g5w1/attendance.xlsx?dl=0

Thanks in advance
Hemanth

 

[hemanthcrpatna]

Hi all
Can any please look into this and help me with formula asap.

Thanks
Hemanth