I have searched, but haven't found the answer to my problem. Any help is appreciated.
Essentially, I have a table with date formulas. I want a final cell to pick the sooner of two date options (using a min formula). But if one of the date cells is blank, I want the final cell to be blank- right now ir treturns a date of 01/00/00.
Here is my table and formulas:
Here is the current formula in column H:
=MIN(IF(OR([@[Satellite ASD]]<>"",[@[Permanent Accumulation Start Date]]<>""),[@[Maximum Satellite Pickup Date]]),[@[Maximum Permanent Pickup Date]]).
Is there a way to leave the H:H cells blank if, let's say, the date in column D or F is missing? I am also appreciative if there is a cleaner way set up these formulas. If it helps, here are the formulas for cells in E and G too:
E:
=IF(B5=List!$A$6,List!$D$6,IF(B5=List!$A$7,List!$D$7,""))
G:
=IF(B5=List!$A$3,List!$D$3,IF(B5=List!$A$4,List!$D$4,IF(B5=List!$A$5,List!$D$5,IF(B5=List!$A$6,List!$D$3,IF(B5=List!$A$7,List!$D$4,IF(B5=List!$A$8,List!$D$8,IF(B5=List!$A$9,List!$D$9,IF(B5=List!$A$10,List!$D$10,""))))))))
Thank you in advance.
Essentially, I have a table with date formulas. I want a final cell to pick the sooner of two date options (using a min formula). But if one of the date cells is blank, I want the final cell to be blank- right now ir treturns a date of 01/00/00.
Here is my table and formulas:
Here is the current formula in column H:
=MIN(IF(OR([@[Satellite ASD]]<>"",[@[Permanent Accumulation Start Date]]<>""),[@[Maximum Satellite Pickup Date]]),[@[Maximum Permanent Pickup Date]]).
Is there a way to leave the H:H cells blank if, let's say, the date in column D or F is missing? I am also appreciative if there is a cleaner way set up these formulas. If it helps, here are the formulas for cells in E and G too:
E:
=IF(B5=List!$A$6,List!$D$6,IF(B5=List!$A$7,List!$D$7,""))
G:
=IF(B5=List!$A$3,List!$D$3,IF(B5=List!$A$4,List!$D$4,IF(B5=List!$A$5,List!$D$5,IF(B5=List!$A$6,List!$D$3,IF(B5=List!$A$7,List!$D$4,IF(B5=List!$A$8,List!$D$8,IF(B5=List!$A$9,List!$D$9,IF(B5=List!$A$10,List!$D$10,""))))))))
Thank you in advance.