Formula/macro help
Put this into the formulae where it's currently stated as
TEXT(NOW(),"yyyy")... however, if T2 is less than 7 characters in
length then there will not be a year value there ??
(TEXT(NOW(),"yyyy")-(TEXT(T2,"yyyy")))
Michael Koerner wrote:
Tried your formula, and it was missing a ")" which I found after a couple of
tries (not to familiar with formula). which provided me with half of what I
want. Now that I have the current year I would like to subtract the yyyy
from "T2", giving me the number of years difference. Thanks for taking the
time to help.
--
Regards
Michael Koerner
"Will Cairns" wrote in message
ups.com...
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
|