Looking for a formula to choose one date or another

  • Thread starter Thread starter michelledean via OfficeKB.com
  • Start date Start date
M

michelledean via OfficeKB.com

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
 
One possibility assuming you dont' want a year of 1900
=IF(YEAR(L10)<>1900,L10,IF(YEAR(k10)<>1900,k10,""))
 
Back
Top