MAX formula that excludes #N/A cells

[excel?]

I have 7 columns A:G starting at A1. Col A is Product Number and Cols B:G either have a Date or a #N/A. I would like to get the MAX date from Columns B:G, but I am only getting #N/A. I'm using =MAX(B1:G1).

My data in Row 1 looks like this:

Is there a formula that will give me the date 07/13/2022 instead of #N/A?

Thank you.

 

[Fluff]

How about

=MAX(FILTER(B1:G1,ISNUMBER(B1:G1)))

 

[excel?]

PERFECT!! Thank you so very much.

 

[Fluff]

You're welcome & thanks for the feedback.