SOLVED

Data Validation restricted to a specific day

%3CLINGO-SUB%20id%3D%22lingo-sub-1481801%22%20slang%3D%22en-US%22%3EData%20Validation%20restricted%20to%20a%20specific%20day%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481801%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20am%20trying%20to%26nbsp%3Bwrite%20a%20data%20validation%20formula%20that%20will%20allow%20to%20write%20data%20in%20a%20table%20only%20on%20a%20specific%20day%2C%20for%20example%20the%2015th%20of%20July%202020.%20I%20think%20only%20a%20custom%20formula%20would%20help%2C%20but%20I%20do%20not%20know%20which%20one...%3C%2FP%3E%3CP%3EThanks%20for%20any%20clue...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1481801%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481857%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Validation%20restricted%20to%20a%20specific%20day%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481857%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F707054%22%20target%3D%22_blank%22%3E%40emese705%3C%2FA%3E%26nbsp%3BThat%20could%20be%20the%20following%20DV%20custom%20formula%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DTODAY()%3DDATE(2020%2C7%2C15)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EIt%20will%20only%20allow%20input%20on%20July%2015%2C%202020.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481959%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Validation%20restricted%20to%20a%20specific%20day%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481959%22%20slang%3D%22en-US%22%3EThank%20you%20very%20much!%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hello, I am trying to write a data validation formula that will allow to write data in a table only on a specific day, for example the 15th of July 2020. I think only a custom formula would help, but I do not know which one...

Thanks for any clue...

2 Replies
Highlighted
Best Response confirmed by emese705 (Occasional Contributor)
Solution

@emese705 That could be the following DV custom formula:

=TODAY()=DATE(2020,7,15)

It will only allow input on July 15, 2020.

Highlighted
Thank you very much!