May 30 2021 09:07 PM
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
May 31 2021 12:00 AM