Forum Discussion

NitinGautam's avatar
NitinGautam
Copper Contributor
Aug 02, 2023

Using If/Then with CONCATENATE

Hello,   I am trying to create a column in a list for a SharePoint site where I am calculating the number of years, months, and days someone has been employed.  Currently I am using the below formu...
Lists
microsoft lists
SharePoint Online
SvenSieverding's avatar
SvenSieverding
Bronze Contributor
Aug 02, 2023

Hi NitinGautam 

you were nearly there ....this should work

=IF(ISBLANK([Rehire Date]), CONCATENATE((ROUNDDOWN(((TODAY()-[Hire Date])/365),1))," yrs"),CONCATENATE((ROUNDDOWN(((TODAY()-[Rehire Date])/365),1))," yrs"))

Best Regards,
Sven

 

  • NitinGautam's avatar
    NitinGautam
    Copper Contributor
    Aug 02, 2023

    SvenSieverding Thank you that's perfect.  I knew I was close I just couldn't figure it out.

Resources