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/kqu4uw783s...2017.xlsx?dl=0

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

Thanks in advance
Hemanth

[protonLeah]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

---

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to Quick Post button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!