Find out the year

[meus]

Hello All, Greetings

I have a list of employees Join date. I want to find out on which date they will reach 5 years from the time of their join date.
Example:
if my join date in a company is 2016/1/1 then at 2021/1/1 i will reach 5 years. I want to find out 2021/1/1 ( my case) from the supplied Join date through formula..
Can anyone help me on this?

Any help is appretiated..
Thanks in advance

[TudyBTH]

Hi,
Capture1.JPG

[oeldere]

=eomonth(A1,59)+1

In the solution in #2 you have probably change the ; (semi colon) into , (comma) (according to your local settings)

[Phuocam]

Or try this ...

=EDATE(A1,5*12)

[Tony Valko]

Or try this ...

=EDATE(A1,5*12)

Or simply...

=EDATE(A1,60)

[meus]

Thanks All Solved

[Tony Valko]

You're welcome. We appreciate the feedback!