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.
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.