View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Will Cairns Will Cairns is offline
external usenet poster
 
Posts: 8
Default 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