Forum Discussion
Solved
need help in using IF formula and EDATE at same time
Hi in this excel sheet I want to put formula if MFD+Expiry is greaten than EDATE(B8,24) then EDATE(B8, 24)) if its less then Reference cell H8
Hi, what exactly do you mean by MFD + Expiry? What do you want to sum? Logic behind? Are you looking for the condition to be met if both dates are greater than?
This might put you into the right direction (only taking into account the expiry date):
=IF(H8>EDATE(B8,24),EDATE(B8,24),H8)
Hi, what exactly do you mean by MFD + Expiry? What do you want to sum? Logic behind? Are you looking for the condition to be met if both dates are greater than?
This might put you into the right direction (only taking into account the expiry date):
=IF(H8>EDATE(B8,24),EDATE(B8,24),H8)
Thanks