I am booking staff holidays and looking for 3 restrictions:
On Holiday Entry Sheet:
Column A when I type "Badge" number and using vlookup it fills B:G except D.
Restriction 1:
If I type a same date for the same staff, I want a error messege "YOU HAVE ALREADY BOOKED THIS DATE".
Restriction 2:
If I type a date and staff is not contracted on that day, I want a error messege "YOU ARE NOT CONTRACTED ON THIS DAY".
Restriction 3:
All the dates I will type will be restricted between a range (i.e. 01/01/2020 to 31/12/2020). Any date I type outside this range would give me a error messege "DATE IS OUTSIDE THE HOLIDAY YEAR"
Bookmarks