I need to calculate time between dates and then use a function to use that as part of a larger calculation. I know how to run the calculation between two dates using "datediff"
I need help with:
If 1 has worked for my company less than 3 mths, 1 gets no sick pay,
if 1 has worked for my company more than 3 mths, but less than 12 mths, then 1 gets 2 weeks full sick pay,
If 1 has worked more than 12 months, one gets 5 weeks full sick pay.
How do I express this in excel 2016 function(s)
Is this possible within one cell, using the difference between two dates.
Thanks very much.
Solved by F. E. in 11 mins