Browse Site by Tags

Showing related tags and posts accross the entire site.

convert date result from date serial to conventional mm/dd/yyyy date from conditoinal formula

=IF((AND(L16="H",H16>0)),(J16-H16+K16),IF((OR(L16="H",H16=0)),(H16+J16+K16),(IF(L16="D",(I16+DATE_TEXT(K16)),IF(L16="C",(H16+J16+K16)))))) When the user selects "d" in L16, the system needs to add a date such as 4/24/2007 in cell I16 and a number of...

Posted to Functions and Formulas (Forum) by stuthill on Mon, Apr 28 2008

Page 1 of 1 (1 items)