Wade Smart wrote:
JOE Conner wrote:
Wade Smart wrote:
I have a group of numbers in a column
265879-09-24-71-918-333-0055
and I need to take the fourth set of numbers, in this case the 71,
and subtract it from the current year to get the age of the item.
Ideas on how to do that?
Wade
Is this a spreadsheet column or is it writer?
Sorry, spreed sheet.
Wade
Assume your numbers are in A1:A7 then in whatever cell you want the age
to appear in, say B4 for example,
input the formula =YEAR(TODAY())-A4 and that should do it.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
