Forum Discussion
Create warning if Date not entered
Hi,
I was wondering if there's a way to have a warning box pop up if a date isn't entered into a specific cell?
Currently using a shared workbook to track document review times and there is a need to have several dates attributed to one document and we get our KPI data from this. the problem I'm currently having is multiple people use this and don't always enter dates correctly, 27/012022, for example and if this isn't picked up on it messes up any data we need for our KPI's etc.
Hope I've made sense with this and any help is much appreciated
billyrichrich83 Use Data Validation for the cells that must have valid dates.
You'll find it on the Data ribbon, under Data Tools. Select "Date" in the Allow box and specify the date range that is permitted. Then you can also stop people from entering valid dates that fall outside a certain time frame. Customize the Input message and Error alert to your liking.
2 Replies
billyrichrich83 Use Data Validation for the cells that must have valid dates.
You'll find it on the Data ribbon, under Data Tools. Select "Date" in the Allow box and specify the date range that is permitted. Then you can also stop people from entering valid dates that fall outside a certain time frame. Customize the Input message and Error alert to your liking.
- Awesome thanks
