help with excel

[BRUTUS22]

im a newby to excel ..trying to work something out.
If date in G1 = H1,then return yes in K1 and N/A in columns L1 to Q1
if false, leave k1 empty and allow input yes or no or n/a

date is dd/mm/yy

thanks in advance

 

[Yongle]

If date in G1 = H1,then return yes in K1 , if false, leave k1 empty

Formula n K1
=IF(G1=H1,"yes","")

You cannot have values and a formula and allow input in L1 to Q1

But you can use data validation on those cells

Select L1:Q1 \ Data tab \ DataValidation \allow LIST \ source yes,no,n/a \ uncheck IgnoreBlanks \ OK