Macro to calculate and insert number of elapsed years?
A company was founded in 1997. Is there a way to make number of years in
business, always current, in a field? i.e., embed a formula that knows
"1997" and can take today's date minus 1997 and insert the number "10" so
that desired boilerplate text says "We've been in business for XX years" and
the number of years will always be correct, year after year, whenever the
field is updated.
|