Concatenate function doesn't work for cells with numerical/date values

Hello,

I am trying to concatenate numerical date values in a cell but Excel keeps returning '#VALUE!' errors no matter what I try. I've tried reformatting the numbers into text, number, general, and date, but I still get the same error.
I can concatenate text just fine, but as soon as I introduce any numbers I get the error.

Specifically, I am trying to format date values into quarterly data using this formula: =YEAR(A2)&": Quarter "&ROUNDUP(MONTH(A2)/3, 0)
I am using the YEAR function to attain the year from the data value, and the ROUNDUP function to attain the quarter of the year the date is in. I have tested the ROUNDUP function and its contents and made sure it returns the correct values, I just seem to get an error when I concatenate by using the formula above, or any variations of it.

This formula worked fine on a different file on my Mac, but now when I'm working on Windows it doesn't seem to work; I'm suspecting I might be using the wrong code for Windows, or there is something wrong in my settings. Any suggestions would be greatly appreciated!

Thanks!

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

With your example =YEAR(A2)&": Quarter "&ROUNDUP(MONTH(A2)/3, 0) I got: 2017: Quarter 1 with =today() in A2
so what is wrong with it?