The last thing I need in my excel spreadsheet is to require a date be input in B6 should the answer in B5 be "yes". The scenario is as follows: B5 can be yes, no or blank. If B5 is no or blank I dont need anything in B6 and the overall answer to all the previous answers will be displayed in B12. However, if B5 is "yes", B6 must have a date before the overall answer can be displayed in B12. Is there a formula to do this? I have tried excel formulas but I believe I may need a visual basic code and I have very little experience with VB. ANy help is GREATLY appreciated!!!!