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

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

    Riny_van_Eekelen 

     

    Reny, thanks!!

     

    Playing with your formula I spotted the problem. The ">" test between the Date_Posted and the Posting_Validation_Date SHOULD have read: ">="

     

    =OR(AB5<AA5,AB5>Todays_Date,AB5>=AD5)

     

    That works!

     

    Thanks

     

    TheOldPutrMan AKAJohn (NotAnotherGrumpyOldMan)

Resources