Drop down list and if function

Copper Contributor

Good morning/ evening,

 

I am trying to link drop down list to if function for the following scenario:

 

For a separating employee, I was able to creat a drop down list that shows service duration in days, months, years. But, when i tried to make calculations of the duration dependent on the selected entry using if function, it did not work.

 

I know about dateif function and so, but I want to see how my idea can be applied.

 

Appreciate your help

1 Reply
If possible then please share the Workbook with us,, help me & others to test our methods with genuine data set to attain correct solution !!