I appreciate any help with this problem.
It is similar to the calculated column questions on here but slightly different. What I have is:
First day of absence > Last day of absence > Half day yes or no (filled in by user) and > Then total days to be shown in a calendar view.
Problem: When a request is put through and accepted, for example an employee is sick from 9/3/15 - 11/3/15. In the calendar this only shows as 9/3/15 - 10/3/15.
I really don't know why this is doing it looking at the calculated column and was wondering if anyone can have a quick look at the formula below:
=IF([Half Day]="No",IF(AND((WEEKDAY([Last Date of Absence],2))<(WEEKDAY([First Date of Absence],2)),((WEEKDAY([First Date of Absence],2))-(WEEKDAY([Last Date of Absence],2)))>1),(((DATEDIF([First Date of Absence],[Last Date of Absence],"D")+1))-(FLOOR((DATEDIF([First Date of Absence],[Last Date of Absence],"D")+1)/7,1)*2)-2),(((DATEDIF([First Date of Absence],[Last Date of Absence],"D")+1))-(FLOOR((DATEDIF([First Date of Absence],[Last Date of Absence],"D")+1)/7,1)*2))),IF(AND((WEEKDAY([Last Date of Absence],2))<(WEEKDAY([First Date of Absence],2)),((WEEKDAY([First Date of Absence],2))-(WEEKDAY([Last Date of Absence],2)))>1),(((DATEDIF([First Date of Absence],[Last Date of Absence],"D")+1))-(FLOOR((DATEDIF([First Date of Absence],[Last Date of Absence],"D")+1)/7,1)*2)-2),(((DATEDIF([First Date of Absence],[Last Date of Absence],"D")+1))-(FLOOR((DATEDIF([First Date of Absence],[Last Date of Absence],"D")+1)/7,1)*2)))-0.5)
Its almost like I am subtracting a day so can I simply add a day instead? But then this will add a day to an employees half day request so instead of half a day will show as 1 and a half days.
Hope I have explained it well enough and thanks in advance.