Date Calculation

burkemrich

I have 3 columns. 1 column is the date that the time begins, the 2nd is a factor that is either 1.5, 3 or 5. It is always one of these three numbers. The 3rd column is for the end date that is auto-calculated by taking the date in column 1 and multiplying it be the factor selected in column 2. How do I do that? I am really racking my brain about this.

Thank you.

Andrée Starå

Hi,

What measure is the Aging For? Days, Weeks or Months? Let's say that it's days. Do you want the Date Aging Ends to be 5 (3 or 1,5) days in the future?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

burkemrich

I need the aging output to be Month, Day and Year in the final output. I should have put on the original post that it is a multiplication problem. 

(Orig. Date)*(Selected Value - 1.5, 3 or 5) = (Future Date)

The selectables are for number of years.

 

Andrée Starå

Ok.

I would translate the selectable list to days, and then it will work but if you need the reference to show as it does now you could have a helper column to calculate the values in the background.

Would that work?

Best,

Andrée

burkemrich

OK. Good thought. I will see what that looks like and post here again if I can't get it to work.

Andrée Starå

Great!

Let me know if you have any questions!

Best,

Andrée