Hi,
I want to calculate the working years to employees as I have hiring date in a column and I want to calculate as today date. So how I can calculate the years of service for every employee.
Thanks
Hi,
I want to calculate the working years to employees as I have hiring date in a column and I want to calculate as today date. So how I can calculate the years of service for every employee.
Thanks
Try
=date.diff(a1,today())
to get a result is years and months.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Try
=DATEDIF(A1,TODAY(),"y")
where A1 is hire date
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks