Hi - I have an excel sheet that has 3 fields:-
C2 - Trip Limit
C3 - Trip Start Date - dd/mm/yyyy
C4 - Trip End Date - dd/mm/yyyy
If a user enters a Trip Limit of 20 in C2 and if the End Date in C3 minus the Start Date in C4 is more than 20, I would like an error message to either warn the user that the Trip Limit needs to be checked or prevent the user from proceeding until they have changed the Start and End Date.
However, if the user enters N/A or NA in C2 Trip Limit, I don't want any error message to appear and they can continue to fill in the sheet.
Please can someone assist with a formula for this. I tried Data Validation to no avail.
Thanks
Kutty
C2 - Trip Limit
C3 - Trip Start Date - dd/mm/yyyy
C4 - Trip End Date - dd/mm/yyyy
If a user enters a Trip Limit of 20 in C2 and if the End Date in C3 minus the Start Date in C4 is more than 20, I would like an error message to either warn the user that the Trip Limit needs to be checked or prevent the user from proceeding until they have changed the Start and End Date.
However, if the user enters N/A or NA in C2 Trip Limit, I don't want any error message to appear and they can continue to fill in the sheet.
Please can someone assist with a formula for this. I tried Data Validation to no avail.
Thanks
Kutty