Date Calculation

burkemrich · 11/19/18

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å · 11/19/18

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 · 11/19/18

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å · 11/19/18

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 · 11/19/18

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å · 11/19/18

Great!

Let me know if you have any questions!

Best,

Andrée

Date Calculation

Comments

Categories