Forum Discussion

TheOldPuterMan's avatar
TheOldPuterMan
Brass Contributor
Apr 17, 2020
Solved

Data Validation not responding as expected

I have a rather simple formula that I'm using to validate a date BUT the validation message is not being triggered when the value of the conditions are true.   I've tested the formula externally an...
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Apr 17, 2020

    TheOldPuterMan Tested you formula and it seems to work as intended. Created a small schedule to demonstrate it. Even included a named range to today's date in Sheet2. Please see attached.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Apr 17, 2020

TheOldPuterMan Tested you formula and it seems to work as intended. Created a small schedule to demonstrate it. Even included a named range to today's date in Sheet2. Please see attached.

TheOldPuterMan's avatar
TheOldPuterMan
Brass Contributor
May 12, 2020

Riny_van_Eekelen 

Belated ty, not getting around to all of my replies as fast as I like. I appreciate your help.

 

TheOldPuterMan

Resources