Date verification

O

Oldjay

I have an input cell date that must be a Sunday
The next colunm over shows this date as a day of the week
I want the second cell to show "Wrong Date" if the date entered is not a
Sunday
 
D

Dave Peterson

=if(weekday(a1)=1,text(a1,"dddd"),"Wrong Date")


I have an input cell date that must be a Sunday
The next colunm over shows this date as a day of the week
I want the second cell to show "Wrong Date" if the date entered is not a
Sunday
Click to expand...
 
D

Dave Peterson

Format|conditional formatting:

Cell value is: Equal to: Wrong date

Excel will change that last string to: ="wrong date"
 
Top