## Solution - Challenge 68 - Need a Data Validation Formula

Below is a proposed solution to the **Challenge 68 - Need a Data Validation Formula**

=IFERROR(IF(ISNUMBER(SEARCH("/",A2)),IF(--RIGHT(A2,4)=2018,AND(--LEFT(A2,2)>=1,

--LEFT(A2,2)<=12),IF(AND(--RIGHT(A2,4)<=2021,

--RIGHT(A2,4)>=2019),AND(--LEFT(A2,2)>=1,--LEFT(A2,2)<=4)))),FALSE)

## Solution - Challenge 69- Need Help in Not Showing Comments

By eforexcel|Tuesday, February 20th, 2018|Categories: Solutions|Tags: Comments|0 Comments

Below is a possible solution to

Challenge 69 - Need Help in Not Showing CommentsThese are not comments but Data Validation Messages..

Select the cell where pop up message is appearing > Data tab > Data Validation > The pop message is in the Input Message > Either you can remove messages or just say clear all.

To remove them in block -

1. Select rows 1 to 7 > Data tab > Data Validation > Clear All

2. Select rows 20 to 22 > Data tab > Data Validation > Clear All