Years of Service Formula in Google Sheets

1
votes

How do I create a formula for years of service in Google Sheets?

This formula is giving me an error in Google Sheets.

=DATEDIF((B6,"7/10/2019", "Y")&" years")

Screenshot of sheet

I wish to have the output state "10 years". I also need to put the end date as TODAY, but when I input Today() as a date, the formula does not work.

2
datedatetimegoogle-sheetsconcatenationgoogle-sheets-formula

2 Answers

1
votes

try:

=DATEDIF(B6; TODAY(); "Y")&" years"

0

0
votes

Too many brackets... try

=DATEDIF(B6,"7/10/2019", "Y")&" years"