Forum Discussion
Solved
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...
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.
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