I have a sharepoint list that has our employee details with several columns, one of whihc is "Number of days Holiday" = 25.
In a seperate list with Calendar view, users create Holiday requests which (data filled in is start date, end date and number of days used) are then sent via the Approval workflow, the calendar is filtered to only show apporved holidays.
I would like to show in the first "Employee data" list the number of holidays used and then in a seperate column show number of days left.
i.e. Number of days holiday = 25 (employee list) -> Days Used = 1 (calendar list) -> Days left (calculated in the employyes list) = 24
This is simpole to do in Excel but in Sharepoint i cannot for the life of me see how to calculate between 2 lists easily.