I have the following calculated column that returns the "Max End Date" field using the following format YYYY/MM/DD.
=YEAR([Max End Date])&"/"&MONTH([Max End Date])&"/"&DAY([Max End Date])
Although this is working well when there is actually a value in it, when there is no value it returns a nonsense 1899/12/30. I would like it to return nothing if the "max end date" field is empty. I know there is a function ISBLANK that accounts for this, but how do I go about integrating it in my existing code?