Formula/macro help
Michael, Not sure why you want to conditionally look for the character
count 6 (if you were testing for omitted yyyy then you would be
checking for LESS THAN 7 "mm/dd/" the formulae below will give you the
current year value if Column T is blank or has <7 characters..
otherwise will give the value of column T.
=IF(AND(T2<"",len(T2<7),TEXT(NOW(),"yyyy"),T2)
HTH,
Will
|