Cell1 must be blank before cell2 can except date
 

Hello to all.
In column F, I have a date for a prelimenary contract and in column G is the
date contract is acepted. I have cells doing calcs on G, only if it contains
a date. What I need is something to say, "You can't enter a date here until
you delete the date in F", when someone tries to enter a date in G. Some
kind of validation formula? Thanks.

Daniel

Cell1 must be blank before cell2 can except date
 

Daniel,

A quick way using Excel features is to select Data then Validation, and in
the Settings tab criteria use the following:
Allow: Select "Date" from pulldown
Data: Select "greater than"
Start Date: enter the formula =F6+F6 (assuming the prelim date is in F5)

Click on the Error Alert tab, make sure the Style is "Stop", enter a Title
for the error, and then your message about "You can't enter..."

Nothing fancy but it works.

"Daniel" wrote:

Hello to all.
In column F, I have a date for a prelimenary contract and in column G is the
date contract is acepted. I have cells doing calcs on G, only if it contains
a date. What I need is something to say, "You can't enter a date here until
you delete the date in F", when someone tries to enter a date in G. Some
kind of validation formula? Thanks.

Daniel