I'm stuck trying to do some basic arithmetic using the YEAR function
I'm trying to derive the number of years that have passed since a boat was either built or underwent a major refit. I have one column for date built and another for date of last refit. First, I wanted to return a blank if there is no last refit date, and then to calculate the number of years since the last refit if there is a date in the last refit column. Once that step has been accomplished, I want to do the same for the year built column.
So far, this unparseable formula is what I've come up with:
=IF([Last Refit]@row="","", SUM(YEAR(TODAY()YEAR([Last Refit]@row))), IF([Year Built]@row"","", SUM(YEAR(TODAY()YEAR([Year Built]@row)))))
I welcome your suggestions!
Answers

I think you might be doing too much based on your description. I'll just try to focus on the Last Refit. I think the formula you're looking for that provides a blank if there is no refit, but returns the number of years since the last refit if there is would be:
=IF(ISDATE([Last Refit]@row), YEAR(TODAY())  YEAR([Last Refit]@row), "")

That worked. Now I just need to figure out how to extend the evaluation to the Year Built column. Thank you!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.9K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.6K Ideas & Feature Requests
 56 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!