automatically entering data into a cell

  • Thread starter Thread starter shanman_lmtd
  • Start date Start date
S

shanman_lmtd

I'm not sure if this is possible but...

I have three columns, a date in the first and last and text in the
middle.

When I enter a date in the start date I would like text to be
automatically displayed (the text is active) in the middle column.

Then when I enter a date in the end date column I would like the text
in the middle column to change to complete.

Any help is much appreciated.

Many thanks
 
Hi

There were couple semicolons instead commas in formula (somehow I missed
them when edited the formula for posting - my Excel uses semicolons as
delimiters).

=IF(AND(A2="",C2=""),"",IF(ISERROR(DAY(A2)),"Start-date isn't
date!",IF(ISERROR(DAY(C2)),"End-date isn't
Date!",IF(AND(A2>0,C2=""),"Active",IF(AND(A2="",C2>0),"Start-date is
missing","Complete")))))

The formula does something more as you asked - it checks for cases where
into date field is entered something that excel can't interpret as date
(p.e. some text string)
 
Back
Top