I'm trying to determine the number of years someone has on the job.
I'm using this formula - =DATEDIF(B7,TODAY(),"m")/12.
This gives me a result of 13.92, how can I round down this calculation to 13.0?
If I remove the decimals...it rounds up to 14 - which is an error.
Thanx.
Bookmarks