Date verification
=if(weekday(a1)=1,text(a1,"dddd"),"Wrong Date")
Oldjay wrote:
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
--
Dave Peterson
|