## Forum Discussion

ReneeHansen1

Qrew Cadet

Ok, I do have a follow up question.

I also have duration formulas (year 1 duration, year 2 duration, year 3 duration, year 4 duration, year 5 duration). I'm not sure where the formula for the Year would go -

Year([BUSINESS CASE START DATE])

Then the formula for [Year 2] would be [Year 1] + 1.

does it go into the duration formula? Or does it go into the Year $ formula?

MarkShnier__You

2 months agoQrew Legend

[Year] will be a formula NUMERIC field type, not duration.

Then the formula for [Year 2] would be [Year 1] + 1

- ReneeHansen12 months agoQrew Cadet
ok, but I think I'm confused because I have all of my formulas built, and I need to slide this one in somewhere - so I'm just not sure where I need to put it to use it effectively.