Determining if price is Yearly or Monthly.

[Travis_Ratliff]

Hello helpful people,

Find attached sample data. What I am trying to do is as the subject says determine how long these prices run either M(onthly) or Y(early). For, example the end result would be:

Price	Increment
54.99	M
59.25	Y
63.76	M

Any help or ideas would be greatly appreciated.

[Yoshiro_Fujimori · Accepted solution]

Hi @Travis_Ratliff ,

On your data, the duration is not unique for each price.

So I made it to decide the "Increment" for each row.

I also assumed that if the duration is 13 month - "Y", 1 month - "M", and all others - blank.

I hope this helps.

Workflow

Formula tool

Start_Date = DateTimeParse([Start Date],"%m/%d/%Y")

End_Date = DateTimeParse([End Date],"%m/%d/%Y")

Duration = DateTimeDiff([End_Date],[Start_Date],"month")

Increment = IF [Duration] = 1 THEN "M" ELSEIF [Duration] = 13 THEN "Y" ELSE "" ENDIF

Output