Hello

I've written the below formula so far but seem to be coming back a bit stuck, I've tried & and : for the range and I think I'm going around in circles. So I'm asking for a bit of help please.

=IF(S255&S256&S257&S258=" ", " ", MAX(S255&S256&S257&S258))

I'm trying to bring back the maximum value once all the cells in this 4 cell range are filled in.
If one of these cells is blank I would like it to report back nothing, and ignore the maximum total.

ie. - I only would like it to return a maximum value once all the 4 fields have a date in them

Help is always appreciated.

Thanks
Matt