Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation Formula
I'm clueless on this one, not even sure if it can be done. I've got a
spreadsheet with the following columns: Date of Birth, Start of Service, End of Service and Days of Service (difference between SoS and EoS), no problem. But in this situation, the SoS and the EoS have to be the same month. Since I've already set validation criteria on those fields, I'm trying to figure out if I can create validation criteria in the Days of Service cell to check to see if both the SoS and EoS are the same month. Does anyone know how to do this? If it can't be done this way, I'll just write code to check it, as I'm already doing other code for other validation criteria that can't be done using the validation criteria function of XL. My first choice is to put it in as Validation Criteria, if possible. Thanks again! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation and Formula | Excel Programming | |||
Data validation formula | Excel Worksheet Functions | |||
data validation formula | Excel Discussion (Misc queries) | |||
Data Validation with Formula | Excel Discussion (Misc queries) | |||
Data Validation Formula Help | Excel Worksheet Functions |