Jun 22 2020 11:54 AM
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...
Jun 22 2020 12:24 PM
Solution@emese705 That could be the following DV custom formula:
=TODAY()=DATE(2020,7,15)
It will only allow input on July 15, 2020.
Jun 22 2020 12:24 PM
Solution@emese705 That could be the following DV custom formula:
=TODAY()=DATE(2020,7,15)
It will only allow input on July 15, 2020.