Date, edate, 5 years multiple formula

[isundari]

Hi. Hello

I have a data of employee effective date.
I want to have a field where month and day is the same, but the year is changing refers to the header column.
And another field with condition:
When service year is less than 12 months, count the month of effective date to current month.
Every 5 years and multiple is 24, others than that is 12.

Thanks in advance for your help!

[binuacs]

@isundari Can you provide some sample data and expected output for better understanding

[isundari]

Hi @binuacs 

Thank u so much for responding my question. 

Here's the data I need. Leave entitlement based on service year in certain year ( eg. 2021 )

Hope u can help me with this

 

thanks again.

[binuacs · Accepted solution]

@isundari 

[isundari]

Wowww cool!

Thank you so much @binuacs 

This is what I've been looking for.

Been doing it well in Excel, but clueless in Alteryx. Now is good, thanks to u.

cheers 

iis