Looking for a formula to choose one date or another
 

I have a form that I need a return in one column of 1 date or the option of
another.

EX:

Column K column L Column P
Date L/T DATE S/S Date Enter System


I need column P to return the date of column L, if there is no date in
column L I need Column P to return the date in column K

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200712/1

Looking for a formula to choose one date or another
 

Try:
=If(L2="", K2, L2)


"michelledean via OfficeKB.com" wrote:

I have a form that I need a return in one column of 1 date or the option of
another.

EX:

Column K column L Column P
Date L/T DATE S/S Date Enter System


I need column P to return the date of column L, if there is no date in
column L I need Column P to return the date in column K

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200712/1

Looking for a formula to choose one date or another
 

One possibility assuming you dont' want a year of 1900
=IF(YEAR(L10)<1900,L10,IF(YEAR(k10)<1900,k10,"") )

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"michelledean via OfficeKB.com" <u11299@uwe wrote in message
news:7c62f9ac81bac@uwe...
I have a form that I need a return in one column of 1 date or the option of
another.

EX:

Column K column L Column P
Date L/T DATE S/S Date Enter System


I need column P to return the date of column L, if there is no date in
column L I need Column P to return the date in column K

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200712/1