JOE Conner wrote:
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.
A1 though A7?
This 265879-09-24-71-918-333-0055 is all in one column.
wade
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
