E
Erinayn
I'm trying to create a "database" for our team so that we can then create a
mail merge for our certificates for anniversaries with the company. I found a
formula that will give me the years of service with some text.
=DATEDIF(G10,$C$1,"y") & " years of service "
G10 = the start date
C1 = today's date
This result gives me "2 years of service" which is great for all but 1 year
of service. Can anyone help me with an if statement for the instance when it
is the first anniversary and I want it to say "1 year of service".
mail merge for our certificates for anniversaries with the company. I found a
formula that will give me the years of service with some text.
=DATEDIF(G10,$C$1,"y") & " years of service "
G10 = the start date
C1 = today's date
This result gives me "2 years of service" which is great for all but 1 year
of service. Can anyone help me with an if statement for the instance when it
is the first anniversary and I want it to say "1 year of service".