Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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". |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Years of Service Calculation | Excel Worksheet Functions | |||
Age and Number Years of Service | Excel Discussion (Misc queries) | |||
Years of Service Question? | New Users to Excel | |||
Years of Service Question? | New Users to Excel | |||
Years of service... | New Users to Excel |