http:\/\/www.boostsolutions.com\/workflow-boost.html<\/a>)<\/p>\nAnnual Entitlement: means the number of days off an employee is entitled to; this is based on the number of years they have worked and the Paid Annual Leave for the current year.<\/p>\n
Actual Annual Entitlement: means the number of days off an employee is entitled to; this is based on the number of days worked in the company and the number of days off an employee is entitled to.<\/p>\n
<\/p>\n
Calculated Column:<\/b><\/p>\n
Annual Entitlement, Actual Annual Entitlement, Start Date, Days left<\/p>\n
<\/p>\n
Formula:<\/b><\/p>\n
Annual Entitlement=IF(Type =”Company”, IF(Today-Date on Board>365,4+ROUNDDOWN(DATEDIF(Date on Board, Today,”d”)\/365,0),0),IF(Today- Work Start Date>7300,15,IF(Today-Work Start Date>3650,10,5)))<\/p>\n
<\/p>\n
Actual Annual Entitlement =IF(Type=”Company”, IF(DATEDIF(Date on Board, Today,”d”)<365,0,ROUNDDOWN(DATEDIF(Date on Board,Today,”d”)\/365,0)+4),IF(DATEDIF(Date on Board,Today,”d”)>365,Annual Entitlement ,ROUNDDOWN((DATEDIF(Date on Board, Start Date ,”d”)\/365*Annual Entitlement),0)))<\/p>\n
<\/p>\n
Start Date =IF(Type =”Company”, DATE(YEAR(Today),MONTH(Date on Board),Day(Date on Board)),DATE(YEAR(Today),12,31))<\/p>\n
<\/p>\n
Annual Leave Remaining = ROUND (Actual Annual Entitlement, 0)-ROUND (Annual Leave Taken,1)<\/p>\n
<\/p>\n
Function description:<\/b><\/p>\n
Function ROUNDOWN: To round down the number of dates between Date on Board and Today.<\/p>\n
Function DATEIF returns the number of days between the Date on Board and the Start Date of Paid Annual Leave.<\/p>\n
<\/p>\n
For more details please refer to<\/p>\n
http:\/\/msdn.microsoft.com\/en-us\/library\/bb862071.aspx<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"SharePoint Foundation’s formulas for calculated fields are based on Microsoft Excel’s functions and syntax. How do you apply it to SharePoint and use it for your business needs? The Scenario: Employee can use SharePoint to check their Paid Annual Leave (number of days taken, number of days left and so on) and then they can […]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[347],"tags":[],"_links":{"self":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/6525"}],"collection":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=6525"}],"version-history":[{"count":6,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/6525\/revisions"}],"predecessor-version":[{"id":9154,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/6525\/revisions\/9154"}],"wp:attachment":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=6525"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=6525"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=6525"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"Logic](\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2014\/01\/Logic-of-Paid-Annual.png\")
<\/p>\n